Wednesday, June 24, 2009

Understanding the long term trend with data

Hi All,

It would be great to have actual rates from various projects recorded over a period of time. This will help us to understand the trend of real estate prices.
The trend should be derived from data gathered from guys like us "on the street", not from some biased reports of property consultants.

The idea is that we can have a database-on-the-web to capture real estate rates.

With a few hours effort, I created a google spreadsheet to record the rates over time from a single project in Kothrud, Pune. The pricelists have been grabbed from the builder's website from March 2009 to June 2009.
The latest pricelist can be viewed here:

The spreadsheet can be viewed here:

Creating a chart, we can see that the rate is the same for the past 4 months!! Compare this with the boom period when rates used to increase every month. Definitely, real estate in Kothrud, Pune has flattened out.

The google spreadsheet is not appropriate for large amounts of data which can start pouring in from various cities, so I have also created a mysql database with multiple tables.

How to gather the data?
1. Quoted by builders - this can be done by gathering pricelists of the projects at exhibitions, or from the website of the builder.
From the pricelist, we need to calculate the carpet area (excluding terraces, balconies, and other non FSI related areas) and the total cost to the buyer (including stamp duty, registration, one time maintanenance etc i.e. everything).
The carpet area, total cost and date can be entered into the database.
Entering pricelists into the database will have to be done by moderators.

2. Posted anonymously by real buyers:
Anyone who has purchased a property can anonymously post the carpet area, total cost and date. The anonymous user is not allowed to enter data directly into the database, he can post in this blog and a few moderators like us who have write permission to the database will enter his post.
What if someone posts a misleading rate? I believe 1o people can lie, but 1000 people will not lie. When we have hundreds and thousands of unique users posting rates, the misleading posts become statistically insignificant. This is the same principle on which operates.
Also a restriction is that a user can post only the rate for a property he has actually bought, so we can restrict posts to 1 post each month per email id.
People can also post links to builder's websites which have published pricelists.

There can be a discussion on how to allow anonymous posts.

We can have admin / moderators for each city, like I and someone else can do for Pune.

I can help with the perl code, sql and database, domain name, hosting, but I aint no website designer. Maybe we can form a team to collaborate on the website?

India's residential sector likely to see oversupply - Crisil

Crisil reporting accurately on the state of the housing market in India.
>>> Real estate companies have been launching newer residential projects at lower prices that >>>are located in "far-flung" locations (exhurbs) from the central business districts of cities. The Reuters article is below.
This statement is 1000% true. We see launches in Kalyan, Virar, Boisar in Mumbai which are 3 hours away from business districts. It makes no sense to commute 1/4 of your life every day and still be under the duress of loans. Life is more then loans and commute. Builders have bought land at sky high prices in the Mumbai suburbs and the only way out for them is an increase in FSI. I think in the coming years the Maharashtra govt will do just that. Prices will drop to more sober levels once that happens. Anyone buying at 8k per sq/ft will be rueing the decision for the rest of the loan life.
India's residential sector likely to see oversupply - Crisil

MUMBAI (Reuters) - India's realty companies will struggle to find buyers for about a fourth of their residential space between 2009 and 2011, the research arm of rating agency Crisil said in a report on Wednesday.

During 2009-2011, Crisil Research said it expects absorption of 506 million sq. ft. over the three years based on its expectation of a GDP growth of 6-6.5 percent in 2009/10, according to its study of 10 cities across India.

Although planned supply has been estimated at 1,202 million sq. ft., this supply "is unlikely to materialise in full due to the credit crunch and relatively sluggish demand," and the actual supply will be around 700 million sq. ft., it said.

This indicates 28 percent will be in oversupply while much of the planned projects will be delayed by up to two years and others in the planning stage, shelved.

Indian real estate saw demand for housing collapse in the second half of 2008 amidst a global credit crunch and the local market became stressed with buyers fearing job losses, Sudhir Nair, head-Crisil Research said.

The market is expected to stabilise in 2010, he added, "the Indian economy will stabilise and start accelerating and there will be stability in the global economy and fund constraints will be eroded."

Builders had also reduced unit sizes and cut prices, which will help stabilise demand, he said.

Residential prices are expected to fall further by 8-10 percent in 2009 before stabilising the next year and Crisil Research expects investors to maintain a cautionary approach until values stabilise, it added in the report.

Real estate companies have been launching newer residential projects at lower prices that are located in "far-flung" locations from the central business districts of cities.

Rotten apples on the blog

Readers and folks who comment on the blog like Priti, Shyna, Vandana, Abeer , the good BB, Retired old man, Bharat, Shriniwas, Shubh Chintak  have  noticed some several off-topic, irrelevant and offensive comments on the blog. I can turn on the moderator mode, however the feedback loop of posting a comment and seeing it visible on the blog immediately is lost. At the end of the day I can clean up the posts and comments.  BB or whoever is masquerading as BB will eventually tire out by entering the CAPTCHA characters, but  if his only goal in life is to troll this blog 24x7 and keep slandering, I will be forced to turn the moderator mode on and then reject all his comments. 

What do you guys think ? I think we have a good discussion going on prices, areas, builders and the collective wisdom of people is helping everyone including myself. I had no idea about the price rise in the DDA cluster of Mayur Vihar, so keep up the good work and let us all keep posting. Even the casual reader has something to contribute so don't be shy. We all are looking for insights from the real world, not bogus planted articles by TOI , Jones Meghraj and others. 

Sunday, June 21, 2009

Resale home market fails to attract buyers

Resale home market fails to attract buyers

MUMBAI: The increase in the demand for housing in the past one month appears to be restricted to resale do not have too many takers, at least not in the large cities. In the case of new projects, developers have been offering attractive discounts, while prices in the resale segment have remained high.

Agreed Sunil Bajaj, another city-based property consultant, “The asking rate for old property market is not in line with the prevailing market rate. In Kandivali (a suburb in western Mumbai), the price of an apartment on the first floor on a per square foot basis was as expensive as the one on the penthouse in the same building.” He added that the flat has remained unsold.

Potential buyers have not been finding the going easy. Amit Desai, a Mumbai-based professional employed in a large business group, is one such person. “For a salaried employee, the rates for older property is out of reach since sellers ask for at least 30% of the price in black. This means you get a loan only on the white component (the price after deducting the black component).”

Industry observers said new property has witnessed a price drop of 30-50% in the past six months that is the result of developers facing a liquidity crunch and falling demand. Some buyers have chosen not to go ahead with the purchase, as they feared the property might not be completed. This has led developers to offer schemes like getting the buyer to make a partial payment initially and pay the rest at the time of possession.