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
Data related to Real Estate of India's Major Cities like Mumbai, Hyderabad, etc.
@kaggle.arvanshul_gurgaon_real_estate_99acres_com
spidSPID | 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 | register_dateREGISTER DATE | posting_datePOSTING DATE | update_dateUPDATE DATE | classCLASS | res_comRES COM | prop_namePROP NAME | property_numberPROPERTY NUMBER | min_priceMIN PRICE | max_priceMAX PRICE | price_sqftPRICE SQFT | proj_idPROJ ID | building_idBUILDING ID | verifiedVERIFIED | map_detailsMAP DETAILS | min_area_sqftMIN AREA SQFT | max_area_sqftMAX AREA SQFT | amenitiesAMENITIES | alt_tagALT TAG | product_typePRODUCT TYPE | top_uspsTOP USPS | expiry_dateEXPIRY DATE | property_type_uPROPERTY TYPE, U | areaAREA | secondary_areaSECONDARY AREA | pricePRICE | prop_headingPROP HEADING | value_labelVALUE LABEL | class_headingCLASS HEADING | class_labelCLASS LABEL | register_date_uREGISTER DATE, U | registered_daysREGISTERED DAYS | primary_tagsPRIMARY TAGS | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
70135726 | Z70135726 | S | Hmda, rera approved residential apartments at kompally town, close to all international schools, college's, with clubhouse, swimming pool, with all amenities provided... Interior provided.. | Residential Apartment | Secunderabad | 1 | 1 | 2 | 5700 | 2 | 4 | 1 | 5 | 23,24,5,17,6,20,21 | 08th Jul, 2023 | 1688833873000 | 1689100520000 | A | R | Evolve | 1 | 6925500 | 6925500 | 5700 | N | {'LATITUDE': '17.575957', 'LONGITUDE': '78.471167'} | 112.877145 | 112.877145 | 5,17,20,21,23,24,6 | ₹69.25 Lac, 2 bhk Residential Apartment in Gundlapochampalli - Entrance | PREMIUM_LISTING | nan | Wed Sep 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 | 1215 sq.ft. | 112.88 sq.m. | 69.25 L | 2 BHK Flat in Gundlapochampalli | Freehold | Dealer: Rainbow Developers | Dealer | Sat Jul 08 2023 22:01:14 GMT+0000 (Coordinated Universal Time) | 1 month ago | ['FEATURED'] | ['READY TO MOVE', 'RESALE'] | 9 | [{'text': '1 Library'}] | Evolve | Evolve | {'CITY': '268', 'CITY_NAME': 'Secunderabad', 'BUILDING_ID': '0', 'BUILDING_NAME': 'Evolve', 'SOCIETY_NAME': 'Evolve', 'LOCALITY_ID': '17934', 'LOCALITY_NAME': 'Gundlapochampalli', 'ADDRESS': None} | 1 | 2 | ||
68489968 | A68489968 | S | Own a 2 BHK apartment in Annes Fortune Greenhomes Swan, Nizampet, Hyderabad for a comfortable living. With a super built-up area of 1155.0 sq. ft. to 1395.0 sq. ft., these 2 BHK apartments are available at a price range of Rs. 69.3 Lac to Rs. 83.7 Lac. Annes Fortune Greenhomes Swan is meticulously… | Residential Apartment | Hyderabad | 2 | 1 | 2 | 6000 | 5 | 20 | N | 12th Apr, 2023 | 1681280380000 | 1681280381000 | B | R | Annes Fortune Greenhomes Swan | 8 | 6930000 | 8370000 | 6000 | 400617 | 1093625 | N | {'LATITUDE': '17.522103', 'LONGITUDE': '78.384846'} | 107.302965 | 129.599685 | nan | Annes Fortune Greenhomes Swan Others | PSEUDO_LISTING | nan | Mon Oct 09 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 | 1155-1395 sq.ft. | 107.3-129.6 sq.m. | 69.3 - 83.7 L | 2 BHK Flat in Nizampet | Freehold | Builder | Builder | Wed Apr 12 2023 11:49:40 GMT+0000 (Coordinated Universal Time) | 4 months ago | ['FEATURED'] | ['UNDER CONSTRUCTION', 'NEW BOOKING', 'RERA'] | 50 | [{'text': '1 Shopping'}, {'text': '3 Religious Places'}, {'text': '9 ATMs'}, {'text': '14 Hospitals'}, {'text': '2 Pharmacys'}, {'text': '1 Bus Depot'}, {'text': '1 Library'}] | Annes Fortune Greenhomes Swan | Annes Fortune Greenhomes Swan | {'CITY': '269', 'CITY_NAME': 'Hyderabad', 'BUILDING_ID': '1093625', 'BUILDING_NAME': 'Annes Fortune Greenhomes Swan', 'SOCIETY_NAME': 'Annes Fortune Greenhomes Swan', 'LOCALITY_ID': '5561', 'LOCALITY_NAME': 'Nizampet', 'ADDRESS': None} | 1 | |||
69555358 | M69555358 | S | This well-known project offers 4 BHK apartments in Nanakramguda, Hyderabad. With a super built-up area, ranging from 2880.0 sq. ft. to 3000.0 sq. ft., the apartments are available at an economical price. The price range is available on request. There are 2 towers. A close attention has been paid to… | Residential Apartment | Hyderabad | 2 | 1 | 4 | 5 | 20 | N | 08th Jun, 2023 | 1686225627000 | 1686225628000 | B | R | The Olympus | 2 | 378897 | 1061980 | N | {'LATITUDE': '17.41977', 'LONGITUDE': '78.34969'} | 267.56064 | 278.709 | nan | The Olympus Others | PSEUDO_LISTING | nan | Tue Dec 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 | 2880-3000 sq.ft. | 267.56-278.71 sq.m. | Price on Request | 4 BHK Flat in Nanakramguda | Freehold | Builder | Builder | Thu Jun 08 2023 17:30:28 GMT+0000 (Coordinated Universal Time) | 2 months ago | [] | ['UNDER CONSTRUCTION', 'NEW BOOKING', 'RERA'] | 11 | [{'text': '1 Metro Station'}, {'text': '1 Shopping'}, {'text': '1 Connectivity'}, {'text': '2 Educations'}, {'text': '1 Hospital'}, {'text': '1 Airport'}, {'text': '1 Railway Station'}, {'text': '1 Office Complex'}, {'text': '1 Amusement Park'}, {'text': '1 Golf Course'}] | The Olympus | The Olympus | {'CITY': '269', 'CITY_NAME': 'Hyderabad', 'BUILDING_ID': '1061980', 'BUILDING_NAME': 'The Olympus', 'SOCIETY_NAME': 'The Olympus', 'LOCALITY_ID': '872', 'LOCALITY_NAME': 'Nanakramguda', 'ADDRESS': None} | 1 | |||||||
69555352 | P69555352 | S | Enjoy a blissful living experience in The Olympus. This residential project encompasses 3 BHK flats in Nanakramguda, Hyderabad and brings you the best of both the worlds – excellent aesthetics and exemplary lifestyle. Its unique highlights include facilities like Car Parking, Lift(s), Party Lawn, J… | Residential Apartment | Hyderabad | 2 | 1 | 3 | 20049 | 5 | 20 | N | 08th Jun, 2023 | 1686225626000 | 1686225627000 | B | R | The Olympus | 2 | 20200000 | 20200000 | 20049 | 378897 | 1061980 | N | {'LATITUDE': '17.41977', 'LONGITUDE': '78.34969'} | 186.73503 | 187.66406 | nan | The Olympus Others | PSEUDO_LISTING | nan | Tue Dec 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 | 2010-2020 sq.ft. | 186.74-187.66 sq.m. | 2.02 - 2.02 Cr | 3 BHK Flat in Nanakramguda | Freehold | Builder | Builder | Thu Jun 08 2023 17:30:27 GMT+0000 (Coordinated Universal Time) | 2 months ago | [] | ['UNDER CONSTRUCTION', 'NEW BOOKING', 'RERA'] | 11 | [{'text': '1 Metro Station'}, {'text': '1 Shopping'}, {'text': '1 Connectivity'}, {'text': '2 Educations'}, {'text': '1 Hospital'}, {'text': '1 Airport'}, {'text': '1 Railway Station'}, {'text': '1 Office Complex'}, {'text': '1 Amusement Park'}, {'text': '1 Golf Course'}] | The Olympus | The Olympus | {'CITY': '269', 'CITY_NAME': 'Hyderabad', 'BUILDING_ID': '1061980', 'BUILDING_NAME': 'The Olympus', 'SOCIETY_NAME': 'The Olympus', 'LOCALITY_ID': '872', 'LOCALITY_NAME': 'Nanakramguda', 'ADDRESS': None} | 1 | |||
70237806 | B70237806 | S | Siva sai infra myra is a residential development in patighanpur, hyderabad. The project is built by siva sai infra projects. They provide 3bhk villa with all necessities. | Independent House/Villa | Hyderabad | 2 | 1 | 3 | 8999 | 5 | N | 14th Jul, 2023 | 1689331616000 | 1689331617000 | B | R | Siva Sai Infra Myra | 4 | 24192000 | 28728000 | 8999 | 407796 | 1112421 | N | {'LATITUDE': '17.513816', 'LONGITUDE': '78.244055'} | 249.723264 | 296.546376 | nan | Siva Sai Infra Myra Others | PSEUDO_LISTING | nan | Wed Jan 10 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | 2 | 2688-3192 sq.ft. | 249.72-296.55 sq.m. | 2.42 - 2.87 Cr | 3 Bedroom House in Kollur | Freehold | Builder | Builder | Fri Jul 14 2023 16:16:56 GMT+0000 (Coordinated Universal Time) | 1 month ago | [] | ['UNDER CONSTRUCTION', 'NEW BOOKING', 'RERA'] | 8 | [{'text': '2 Connectivities'}, {'text': '1 Education'}, {'text': '2 Hospitals'}, {'text': '1 Airport'}, {'text': '1 Office Complex'}, {'text': '1 Miscellaneous'}] | Siva Sai Infra Myra | Siva Sai Infra Myra | {'CITY': '269', 'CITY_NAME': 'Hyderabad', 'BUILDING_ID': '1112421', 'BUILDING_NAME': 'Siva Sai Infra Myra', 'SOCIETY_NAME': 'Siva Sai Infra Myra', 'LOCALITY_ID': '46844', 'LOCALITY_NAME': 'Kollur', 'ADDRESS': None} | nan | ||||
69662330 | Z69662330 | S | Make Iris by Raghava your next home. This project offers 4 BHK flats in Gachibowli, Hyderabad. With a super built-up area ranging from 5425.0 sq. ft. to 6605.0 sq. ft., these flats combine the finest design and amenities in Hyderabad to provide a living experience unlike any other. It is an under c… | Residential Apartment | Hyderabad | 2 | 1 | 4 | 14000 | 5 | 45 | N | 14th Jun, 2023 | 1686728099000 | 1686728100000 | B | R | Iris by Raghava | 3 | 75950000 | 92470000 | 14000 | 399658 | 1092216 | N | {'LATITUDE': '17.42107', 'LONGITUDE': '78.38372'} | 503.998775 | 613.624315 | nan | Iris by Raghava Others | PSEUDO_LISTING | nan | Mon Dec 11 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 | 5425-6605 sq.ft. | 504-613.62 sq.m. | 7.59 - 9.25 Cr | 4 BHK Flat in Gachibowli | Freehold | Builder | Builder | Wed Jun 14 2023 13:04:59 GMT+0000 (Coordinated Universal Time) | 2 months ago | [] | ['UNDER CONSTRUCTION', 'NEW BOOKING', 'RERA'] | 13 | [{'text': '1 Metro Station'}, {'text': '1 Shopping'}, {'text': '2 Connectivities'}, {'text': '2 Educations'}, {'text': '1 Hospital'}, {'text': '1 Airport'}, {'text': '1 Park'}, {'text': '1 Railway Station'}, {'text': '1 Office Complex'}, {'text': '1 Hotels'}, {'text': '1 Amusement Park'}] | Iris by Raghava | Iris by Raghava | {'CITY': '269', 'CITY_NAME': 'Hyderabad', 'BUILDING_ID': '1092216', 'BUILDING_NAME': 'Iris by Raghava', 'SOCIETY_NAME': 'Iris by Raghava', 'LOCALITY_ID': '5136', 'LOCALITY_NAME': 'Gachibowli', 'ADDRESS': None} | 1 | |||
70679968 | S70679968 | S | KSR Greens is an under construction project, offering 3 BHK flats in Madinaguda, Hyderabad. These flats have a super built-up area in the range of 1600.0 sq. ft. to 1900.0 sq. ft. and are available at an economical price of Rs. 1.25 Crore - Rs. 1.48 Crore. It is well connected to the city areas and… | Residential Apartment | Hyderabad | 2 | 1 | 3 | 7800 | 5 | 30 | N | 08th Aug, 2023 | 1691472550000 | 1691472550000 | B | R | KSR Greens | 4 | 12480000 | 14820000 | 7800 | 380938 | 1065299 | N | {'LATITUDE': '17.49148', 'LONGITUDE': '78.34096'} | 148.6448 | 176.5157 | nan | KSR Greens Others | PSEUDO_LISTING | nan | Fri Feb 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 | 1600-1900 sq.ft. | 148.64-176.52 sq.m. | 1.25 - 1.48 Cr | 3 BHK Flat in Madinaguda | Freehold | Builder | Builder | Tue Aug 08 2023 10:59:10 GMT+0000 (Coordinated Universal Time) | 2 weeks ago | [] | ['UNDER CONSTRUCTION', 'NEW BOOKING', 'RERA'] | 9 | [{'text': '1 Metro Station'}, {'text': '1 Shopping'}, {'text': '2 Connectivities'}, {'text': '2 Educations'}, {'text': '1 Hospital'}, {'text': '1 Airport'}, {'text': '1 Railway Station'}] | KSR Greens | KSR Greens | {'CITY': '269', 'CITY_NAME': 'Hyderabad', 'BUILDING_ID': '1065299', 'BUILDING_NAME': 'KSR Greens', 'SOCIETY_NAME': 'KSR Greens', 'LOCALITY_ID': '5202', 'LOCALITY_NAME': 'Madinaguda', 'ADDRESS': None} | 1 | |||
70148736 | I70148736 | S | Pragati green meadows in shankerpally, hyderabad by pragati green living is a residential project. The project offers residential plotting with the perfect combination of contemporary architecture and features to provide a comfortable living. The project is spread over a total area of 1000 acr… | Residential Land | Hyderabad | 2 | 1 | 3333 | N | 10th Jul, 2023 | 1688943703000 | 1688943704000 | B | R | Pragati Green Meadows | 5 | 8009199 | 29997000 | 3333 | 85819 | 400587 | N | {'LATITUDE': '17.388172', 'LONGITUDE': '78.181228'} | 223.245909 | 836.127 | nan | Pragati Green Meadows Others | PSEUDO_LISTING | nan | Sat Jan 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | 3 | 2403-9000 sq.ft. | 223.25-836.13 sq.m. | 80.09 L - 3 Cr | Residential land / Plot in Shankarpally | Freehold | Builder | Builder | Mon Jul 10 2023 04:31:43 GMT+0000 (Coordinated Universal Time) | 1 month ago | [] | ['READY TO MOVE', 'NEW BOOKING'] | 5 | [{'text': '1 Connectivity'}, {'text': '1 Education'}, {'text': '1 Hotels'}, {'text': '2 Miscellaneouss'}] | Pragati Green Meadows | Pragati Green Meadows | {'CITY': '269', 'CITY_NAME': 'Hyderabad', 'BUILDING_ID': '400587', 'BUILDING_NAME': 'Pragati Green Meadows', 'SOCIETY_NAME': 'Pragati Green Meadows', 'LOCALITY_ID': '2698', 'LOCALITY_NAME': 'Shankarpally', 'ADDRESS': None} | nan | ||||||
67722344 | M67722344 | S | Book your 3 BHK flat in Aditya Athena, Shaikpet, Hyderabad. Having a super built-up area of 1770.0 sq. ft. - 2390.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 offers resident… | Residential Apartment | Hyderabad | 2 | 1 | 3 | 10169 | 5 | 15 | N | 06th Mar, 2023 | 1678096062000 | 1678096063000 | B | R | Aditya Athena | 26 | 17999130 | 24303910 | 10169 | 337671 | 1010285 | N | {'LATITUDE': '17.407369', 'LONGITUDE': '78.388221'} | 164.43831 | 222.03817 | nan | Aditya Athena Others | PSEUDO_LISTING | nan | Sat Sep 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 | 1770-2390 sq.ft. | 164.44-222.04 sq.m. | 1.8 - 2.43 Cr | 3 BHK Flat in Shaikpet | Freehold | Builder | Builder | Mon Mar 06 2023 15:17:43 GMT+0000 (Coordinated Universal Time) | 5 months ago | [] | ['UNDER CONSTRUCTION', 'NEW BOOKING', 'RERA'] | 12 | [{'text': '1 Metro Station'}, {'text': '1 Shopping'}, {'text': '1 Connectivity'}, {'text': '2 Educations'}, {'text': '1 Hospital'}, {'text': '1 Airport'}, {'text': '1 Railway Station'}, {'text': '1 Office Complex'}, {'text': '1 Hotels'}, {'text': '1 Golf Course'}, {'text': '1 Stadium'}] | Aditya Athena | Aditya Athena | {'CITY': '269', 'CITY_NAME': 'Hyderabad', 'BUILDING_ID': '1010285', 'BUILDING_NAME': 'Aditya Athena', 'SOCIETY_NAME': 'Aditya Athena', 'LOCALITY_ID': '3479', 'LOCALITY_NAME': 'Shaikpet', 'ADDRESS': None} | 1 | |||
69323950 | B69323950 | S | Lavish, is the only way to describe these beautiful 3bhk and 4bhk villas in bowrampet, hyderabad. Tripura landmark 4 villas built by tripura constructions builders have everything you would ever expect in a true luxury accommodation. Extended over a wide area, the architecture and attention to detai… | Independent House/Villa | Hyderabad | 2 | 1 | 4 | 10000 | 5 | N | 27th May, 2023 | 1685168425000 | 1685168426000 | B | R | Tripura Landmark 4 | 1 | 29060000 | 29060000 | 10000 | 409999 | 1115346 | N | {'LATITUDE': '17.574527971682', 'LONGITUDE': '78.409721132955'} | 269.976118 | 269.976118 | nan | Tripura Landmark 4 Others | PSEUDO_LISTING | nan | Thu Nov 23 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | 2 | 2906 sq.ft. | 269.98 sq.m. | 2.91 Cr | 4 Bedroom House in Bowrampet | Freehold | Builder | Builder | Sat May 27 2023 11:50:25 GMT+0000 (Coordinated Universal Time) | 3 months ago | [] | ['UNDER CONSTRUCTION', 'NEW BOOKING', 'RERA'] | 8 | [{'text': '1 Shopping'}, {'text': '1 Connectivity'}, {'text': '2 Educations'}, {'text': '1 Hospital'}, {'text': '1 Airport'}, {'text': '1 Railway Station'}, {'text': '1 Hotels'}] | Tripura Landmark 4 | Tripura Landmark 4 | {'CITY': '269', 'CITY_NAME': 'Hyderabad', 'BUILDING_ID': '1115346', 'BUILDING_NAME': 'Tripura Landmark 4', 'SOCIETY_NAME': 'Tripura Landmark 4', 'LOCALITY_ID': '8298', 'LOCALITY_NAME': 'Bowrampet', 'ADDRESS': None} | nan |
CREATE TABLE hyderabad (
"spid" BIGINT,
"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,
"register_date" VARCHAR,
"posting_date" DOUBLE,
"update_date" BIGINT,
"class" VARCHAR,
"res_com" VARCHAR,
"prop_name" VARCHAR,
"property_number" BIGINT,
"min_price" BIGINT,
"max_price" BIGINT,
"price_sqft" DOUBLE,
"proj_id" BIGINT,
"building_id" BIGINT,
"verified" VARCHAR,
"map_details" VARCHAR,
"min_area_sqft" DOUBLE,
"max_area_sqft" DOUBLE,
"amenities" VARCHAR,
"alt_tag" VARCHAR,
"product_type" VARCHAR,
"top_usps" VARCHAR,
"expiry_date" TIMESTAMP,
"property_type_u" BIGINT,
"area" VARCHAR,
"secondary_area" VARCHAR,
"price" VARCHAR,
"prop_heading" VARCHAR,
"value_label" VARCHAR,
"class_heading" VARCHAR,
"class_label" VARCHAR,
"register_date_u" TIMESTAMP,
"registered_days" VARCHAR,
"primary_tags" 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
);
Anyone who has the link will be able to view this.