Indian Real Estate - 99acres.com
Data related to Real Estate of India's Major Cities like Mumbai, Hyderabad, etc.
@kaggle.arvanshul_gurgaon_real_estate_99acres_com
Kolkata
@kaggle.arvanshul_gurgaon_real_estate_99acres_com.kolkata
- 2.33 MB
- 8797 rows
- 35 columns
prop_idPROP ID | preferencePREFERENCE | descriptionDESCRIPTION | property_typePROPERTY TYPE | cityCITY | transact_typeTRANSACT TYPE | owntypeOWNTYPE | bedroom_numBEDROOM NUM | price_per_unit_areaPRICE PER UNIT AREA | furnishFURNISH | facingFACING | ageAGE | total_floorTOTAL FLOOR | featuresFEATURES | prop_namePROP NAME | price_sqftPRICE SQFT | map_detailsMAP DETAILS | amenitiesAMENITIES | areaAREA | pricePRICE | prop_headingPROP HEADING | secondary_tagsSECONDARY TAGS | total_landmark_countTOTAL LANDMARK COUNT | formatted_landmark_detailsFORMATTED LANDMARK DETAILS | society_nameSOCIETY NAME | building_nameBUILDING NAME | locationLocation | balcony_numBALCONY NUM | floor_numFLOOR NUM | carpet_sqftCARPET SQFT | superbuiltup_sqftSUPERBUILTUP SQFT | builtup_sqftBUILTUP SQFT | super_areaSUPER AREA | superarea_unitSUPERAREA UNIT | super_sqftSUPER SQFT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Y71306776 | S | Book your 2 BHK flat in Srijan Star Swapno Puron, Amtala , Kolkata South. Having a super built-up area of 518.0 sq. ft. - 623.0 sq. ft., these flats promise an exclusive view and refreshing vibes, making them well ventilated. It is a superbly design project set amidst excellent surroundings and off… | Residential Apartment | Kolkata South | 2 | 1 | 2 | 3662 | 5 | 3 | N | Srijan Star Swapno Puron | 3662 | {'LATITUDE': '22.364447', 'LONGITUDE': '88.274642'} | nan | 518-623 sq.ft. | 19.1 L Onwards | 2 BHK Flat in Amtala | ['UNDER CONSTRUCTION', 'NEW BOOKING', 'RERA | HIRA'] | 2 | [{'category': 'Shopping', 'text': '1 Shopping', 'className': 'shpng', 'icon': 'https://static.99acres.com/universalapp/img/shpng.png'}, {'category': 'Hospital', 'text': '1 Hospital', 'className': 'hsptl', 'icon': 'https://static.99acres.com/universalapp/img/hsptl.png'}] | Srijan Star Swapno Puron | Srijan Star Swapno Puron | {'CITY': '27', 'CITY_NAME': 'Kolkata South', 'LOCALITY_ID': '8005', 'LOCALITY_NAME': 'Amtala ', 'ADDRESS': None} | 1 | nan | ||||||||
| B70113976 | S | Make Natural Quest your next home. This project offers 3 BHK flats in EM Bypass, Kolkata South. With a built-up area ranging from 1110.0 sq. ft. to 1121.0 sq. ft., these flats combine the finest design and amenities in Kolkata South to provide a living experience unlike any other. It is a new launc… | Residential Apartment | Kolkata South | 2 | 1 | 3 | 10500 | 5 | 11 | N | Natural Quest | 10500 | {'LATITUDE': '22.518795', 'LONGITUDE': '88.388439'} | nan | 1110-1121 sq.ft. | 1.17 - 1.18 Cr | 3 BHK Flat in EM Bypass | ['UNDER CONSTRUCTION', 'NEW LAUNCH', 'NEW BOOKING', 'RERA | HIRA'] | 9 | [{'category': 'MetroStation', 'text': '1 Metro Station', 'className': 'mstn', 'icon': 'https://static.99acres.com/universalapp/img/mstn.png'}, {'category': 'Shopping', 'text': '2 Shoppings', 'className': 'shpng', 'icon': 'https://static.99acres.com/universalapp/img/shpng.png'}, {'category': 'Educati… | Natural Quest | Natural Quest | {'CITY': '27', 'CITY_NAME': 'Kolkata South', 'LOCALITY_ID': '603', 'LOCALITY_NAME': 'EM Bypass', 'ADDRESS': None} | 1 | nan | ||||||||
| O70374510 | S | Book your 3 BHK apartment in Garia, Kolkata South at a price ranging from Rs. 1.22 Crore to Rs. 1.35 Crore. The Ganguly 4Sight Eminence hosts exclusively designed towers, each presenting an epitome of class and simplicity. The residential apartments have a super built-up area of 1376.0 sq. ft. to 1… | Residential Apartment | Kolkata South | 2 | 1 | 3 | 8900 | 5 | 20 | N | Ganguly 4Sight Eminence | 8900 | {'LATITUDE': '22.5137646', 'LONGITUDE': '88.3666797'} | nan | 1376-1516 sq.ft. | 1.22 - 1.35 Cr | 3 BHK Flat in Garia | ['UNDER CONSTRUCTION', 'NEW LAUNCH', 'NEW BOOKING', 'RERA | HIRA'] | 6 | [{'category': 'Shopping', 'text': '1 Shopping', 'className': 'shpng', 'icon': 'https://static.99acres.com/universalapp/img/shpng.png'}, {'category': 'Education', 'text': '2 Educations', 'className': 'schl', 'icon': 'https://static.99acres.com/universalapp/img/schl.png'}, {'category': 'Hospital', 'te… | Ganguly 4Sight Eminence | Ganguly 4Sight Eminence | {'CITY': '27', 'CITY_NAME': 'Kolkata South', 'LOCALITY_ID': '651', 'LOCALITY_NAME': 'Garia', 'ADDRESS': None} | 1 | nan | ||||||||
| Q69170182 | S | Dev bhumi in joka, kolkata south by ocean land developer is a residential project. Dev bhumi price ranges from 1.49 cr to 5.99 cr. It also offers car parking. The project is spread over a total area of 2 acres of land. It has 50% of open space. An accommodation of 500 units has been provid… | Residential Land | Kolkata South | 2 | 1 | 208 | N | Dev Bhumi | 208 | {'LATITUDE': '22.45383', 'LONGITUDE': '88.249572'} | nan | 720-2880 sq.ft. | 1.5 - 5.99 L | Residential land / Plot in Joka | ['READY TO MOVE', 'NEW BOOKING'] | 13 | [{'category': 'MetroStation', 'text': '2 Metro Stations', 'className': 'mstn', 'icon': 'https://static.99acres.com/universalapp/img/mstn.png'}, {'category': 'Connectivity', 'text': '1 Connectivity', 'className': 'hw', 'icon': 'https://static.99acres.com/universalapp/img/hw.png'}, {'category': 'Educa… | Dev Bhumi | Dev Bhumi | {'CITY': '27', 'CITY_NAME': 'Kolkata South', 'LOCALITY_ID': '844', 'LOCALITY_NAME': 'Joka', 'ADDRESS': None} | nan | nan | |||||||||||
| F69917588 | S | Let your dream of owning a flat come true with DTC Sojon. It offers an exclusive range of 3 BHK flats in Joka, Kolkata South. They are available at price of Rs. 60 Lac - Rs. 75 Lac and have a super built-up area of 1130.0 sq. ft. to 1460.0 sq. ft. The project is a secured gated community that furth… | Residential Apartment | Kolkata South | 2 | 1 | 3 | 5215 | 5 | 19 | N | DTC Sojon | 5215 | {'LATITUDE': '22.44213', 'LONGITUDE': '88.29551'} | nan | 1130-1460 sq.ft. | 60 - 75 L | 3 BHK Flat in Joka | ['UNDER CONSTRUCTION', 'NEW BOOKING'] | 11 | [{'category': 'MetroStation', 'text': '1 Metro Station', 'className': 'mstn', 'icon': 'https://static.99acres.com/universalapp/img/mstn.png'}, {'category': 'Shopping', 'text': '1 Shopping', 'className': 'shpng', 'icon': 'https://static.99acres.com/universalapp/img/shpng.png'}, {'category': 'Connecti… | DTC Sojon | DTC Sojon | {'CITY': '27', 'CITY_NAME': 'Kolkata South', 'LOCALITY_ID': '844', 'LOCALITY_NAME': 'Joka', 'ADDRESS': None} | 1 | nan | ||||||||
| Y69917586 | S | DTC Sojon offers 2 BHK apartments in Joka, Kolkata South, at an affordable price range of Rs. 45 Lac to Rs. 49 Lac. These are an under construction apartments spreading across a super built-up area of 880.0 sq. ft. - 960.0 sq. ft. There are a total of 11 towers in the project. The project offers in… | Residential Apartment | Kolkata South | 2 | 1 | 2 | 5108 | 5 | 19 | N | DTC Sojon | 5108 | {'LATITUDE': '22.44213', 'LONGITUDE': '88.29551'} | nan | 880-960 sq.ft. | 45 - 49 L | 2 BHK Flat in Joka | ['UNDER CONSTRUCTION', 'NEW BOOKING'] | 11 | [{'category': 'MetroStation', 'text': '1 Metro Station', 'className': 'mstn', 'icon': 'https://static.99acres.com/universalapp/img/mstn.png'}, {'category': 'Shopping', 'text': '1 Shopping', 'className': 'shpng', 'icon': 'https://static.99acres.com/universalapp/img/shpng.png'}, {'category': 'Connecti… | DTC Sojon | DTC Sojon | {'CITY': '27', 'CITY_NAME': 'Kolkata South', 'LOCALITY_ID': '844', 'LOCALITY_NAME': 'Joka', 'ADDRESS': None} | 1 | nan | ||||||||
| G68329262 | S | Make The Signature your next home. This project offers 3 BHK flats in New Alipore, Kolkata South. With a super built-up area ranging from 1289.0 sq. ft. to 1422.0 sq. ft., these flats combine the finest design and amenities in Kolkata South to provide a living experience unlike any other. It is a r… | Residential Apartment | Kolkata South | 2 | 1 | 3 | 7048 | 5 | 11 | N | The Signature | 7048 | {'LATITUDE': '22.499927', 'LONGITUDE': '88.32487'} | nan | 1289-1422 sq.ft. | 90.85 L Onwards | 3 BHK Flat in New Alipore | ['UNDER CONSTRUCTION', 'NEW BOOKING', 'RERA | HIRA'] | 48 | [{'category': 'Shopping', 'text': '1 Shopping', 'className': 'shpng', 'icon': 'https://static.99acres.com/universalapp/img/shpng.png'}, {'category': 'ReligiousPlace', 'text': '6 Religious Places', 'className': 'rlgs', 'icon': 'https://static.99acres.com/universalapp/img/rlgs.png'}, {'category': 'ATM… | The Signature | The Signature | {'CITY': '27', 'CITY_NAME': 'Kolkata South', 'LOCALITY_ID': '1465', 'LOCALITY_NAME': 'New Alipore', 'ADDRESS': None} | 1 | nan | ||||||||
| J71214794 | S | Experience a new style of living with Bhawani Bandhan. It offers an exclusive range of 2 BHK apartments in Madhyamgram, Kolkata North. Here is a steal deal for you. Book your 2 BHK apartment here at a never before price of Rs. 39 Lac. The unit has a super built-up area of 920.0 sq. ft. This is an … | Residential Apartment | Kolkata North | 2 | 1 | 2 | 4239 | 5 | 11 | N | Bhawani Bandhan | 4239 | {'LATITUDE': '22.690003', 'LONGITUDE': '88.45908'} | nan | 920 sq.ft. | 39 L | 2 BHK Flat in Madhyamgram | ['UNDER CONSTRUCTION', 'NEW BOOKING', 'RERA | HIRA'] | 27 | [{'category': 'ReligiousPlace', 'text': '5 Religious Places', 'className': 'rlgs', 'icon': 'https://static.99acres.com/universalapp/img/rlgs.png'}, {'category': 'Hospital', 'text': '15 Hospitals', 'className': 'hsptl', 'icon': 'https://static.99acres.com/universalapp/img/hsptl.png'}, {'category': 'A… | Bhawani Bandhan | Bhawani Bandhan | {'CITY': '26', 'CITY_NAME': 'Kolkata North', 'LOCALITY_ID': '528', 'LOCALITY_NAME': 'Madhyamgram', 'ADDRESS': None} | 1 | 920 | nan | |||||||
| K71064488 | S | Symphony Proxima is a new launch project, offering 3 BHK flats in Kamalgazi, Kolkata South. These flats have a super built-up area in the range of 1120.0 sq. ft. to 1280.0 sq. ft. and are available at an economical price of Rs. 52.64 Lac - Rs. 60.16 Lac. It is well connected to the city areas and f… | Residential Apartment | Kolkata South | 2 | 1 | 3 | 4700 | 5 | 5 | N | Symphony Proxima | 4700 | {'LATITUDE': '22.44497560154', 'LONGITUDE': '88.390239965808'} | nan | 1120-1280 sq.ft. | 52.64 - 60.16 L | 3 BHK Flat in Kamalgazi | ['UNDER CONSTRUCTION', 'NEW LAUNCH', 'NEW BOOKING', 'RERA | HIRA'] | 7 | [{'category': 'MetroStation', 'text': '1 Metro Station', 'className': 'mstn', 'icon': 'https://static.99acres.com/universalapp/img/mstn.png'}, {'category': 'Shopping', 'text': '1 Shopping', 'className': 'shpng', 'icon': 'https://static.99acres.com/universalapp/img/shpng.png'}, {'category': 'Educatio… | Symphony Proxima | Symphony Proxima | {'CITY': '27', 'CITY_NAME': 'Kolkata South', 'LOCALITY_ID': '6849', 'LOCALITY_NAME': 'Kamalgazi', 'ADDRESS': None} | 1 | nan | ||||||||
| Q71064486 | S | This well-known project offers 2 BHK apartments in Kamalgazi, Kolkata South. With a super built-up area, ranging from 885.0 sq. ft. to 890.0 sq. ft., the apartments are available at an economical price range of Rs. 41.59 Lac to Rs. 41.83 Lac. There are 3 towers. A close attention has been paid to e… | Residential Apartment | Kolkata South | 2 | 1 | 2 | 4700 | 5 | 5 | N | Symphony Proxima | 4700 | {'LATITUDE': '22.44497560154', 'LONGITUDE': '88.390239965808'} | nan | 885-890 sq.ft. | 41.6 - 41.83 L | 2 BHK Flat in Kamalgazi | ['UNDER CONSTRUCTION', 'NEW LAUNCH', 'NEW BOOKING', 'RERA | HIRA'] | 7 | [{'category': 'MetroStation', 'text': '1 Metro Station', 'className': 'mstn', 'icon': 'https://static.99acres.com/universalapp/img/mstn.png'}, {'category': 'Shopping', 'text': '1 Shopping', 'className': 'shpng', 'icon': 'https://static.99acres.com/universalapp/img/shpng.png'}, {'category': 'Educatio… | Symphony Proxima | Symphony Proxima | {'CITY': '27', 'CITY_NAME': 'Kolkata South', 'LOCALITY_ID': '6849', 'LOCALITY_NAME': 'Kamalgazi', 'ADDRESS': None} | 1 | nan |
CREATE TABLE kolkata (
"prop_id" VARCHAR,
"preference" VARCHAR,
"description" VARCHAR,
"property_type" VARCHAR,
"city" VARCHAR,
"transact_type" DOUBLE,
"owntype" BIGINT,
"bedroom_num" DOUBLE,
"price_per_unit_area" DOUBLE,
"furnish" BIGINT,
"facing" BIGINT,
"age" BIGINT,
"total_floor" DOUBLE,
"features" VARCHAR,
"prop_name" VARCHAR,
"price_sqft" DOUBLE,
"map_details" VARCHAR,
"amenities" VARCHAR,
"area" VARCHAR,
"price" VARCHAR,
"prop_heading" VARCHAR,
"secondary_tags" VARCHAR,
"total_landmark_count" DOUBLE,
"formatted_landmark_details" VARCHAR,
"society_name" VARCHAR,
"building_name" VARCHAR,
"location" VARCHAR,
"balcony_num" DOUBLE,
"floor_num" VARCHAR,
"carpet_sqft" DOUBLE,
"superbuiltup_sqft" DOUBLE,
"builtup_sqft" DOUBLE,
"super_area" DOUBLE,
"superarea_unit" VARCHAR,
"super_sqft" DOUBLE
);