Web-scraping real estate with geo location of property in lat long

1. New projects :  https://www.squareyards.com/property-in-gurgaon
1. Detail of a new project : click on a listing in above link. https://www.squareyards.com/gurgaon-residential-property/mapsko-mount-ville/404/project
2. Data -
1. Project details
1. Project Name
2. Locality
3. Project RERA
4. Price Range
5. Status
6. Area
7. Total units
8. Other Features
9. Location - lat long
10. Amenities (plz split into required columns)
11. Builder Name
12. Builder projects
13. Builder Experience
2. Apartment table -
1. Project Name
2. Type - 3bhk, 4bhk etc
3. Title - eg 3 BHK 1490 Sq. Ft. Flat
4. Layout - 3 Bedrooms + 3 Bathrooms + 1 Kitchen
5. Area
6. Price
3. Rental table -
1. S.No.
2. Title
3. Rental price
4. Sq ft
4. Resale table
2. Resale : https://www.squareyards.com/sale/property-for-sale-in-gurgaon
1. Details of a resale project : https://www.squareyards.com/resale-3-5-bhk-servant-room-215-sq-yd-builder-floor-in-sushant-lok-phase...
2. Data -
1. Project table
1. Name
2. Price
3. Locality
4. Property info (to be broken into further columns) - area, address, floor no. etc
5. Amenities (to be broken into further columns)
6. Location - lat long