Zameen.com 2021 Latest Raw Data Set

Latest data set of pakistan realestate industry

@kaggle.huzzefakhan_zameencom_2021_latest_raw_data_set

Table List

2 tables(14.3 MB)

Property Details Tbl

@kaggle.huzzefakhan_zameencom_2021_latest_raw_data_set.property_details_tbl

6.39 MB
16910 rows
26 columns

property_id Property Id	location_id Location Id	page_url Page Url	type_id Type Id	n__type Type	price Price	price_1 Price 1	location Location	city_id City Id	city City	province_id Province Id	province Province	latitude Latitude	longitude Longitude	baths Baths	area Area	purpose_id Purpose Id	n__purpose Purpose	bedrooms Bedrooms	date_added Date Added	description Description	agency_id Agency Id	n__agency Agency	agent_id Agent Id	n__agent Agent	amenities Amenities
311667	162	https://www.zameen.com/Property/islamabad_f_10_beautiful_house_for_sale-311667-162-1.html	39	House	35000000	PKR3.5 Crore	F-10	31	Islamabad	31	Islamabad Capital	33.691531	73.005431	6	1 Kanal	29	For Sale	5	11-23-2021	An ideal house is available for sale. It is situated in Sector F-10, Islamabad. Its measuring area is 500 square yards and it is ideal for residential purpose. It has 5 bedrooms with attached bathrooms, beautiful lawn, servant quarter and also all those things which are important for living. House h…	1813	MAC Estate & Builders	2602	Muhammad Ali, Muhammad Sufiyan, Muhammad Ali	PKR3.5 Crore\|
311670	162	https://www.zameen.com/Property/islamabad_f_10_five_beds_house_for_sale-311670-162-1.html	39	House	32500000	PKR3.25 Crore	F-10	31	Islamabad	31	Islamabad Capital	33.691531	73.005431	5	1 Kanal	29	For Sale	5	11-23-2021	An ideal house is available for sale. It is situated in Sector F-10, Islamabad. Its measuring area is 500 square yards and it is ideal for residential purpose. It has 5 bedrooms with attached bathrooms, beautiful lawn, servant quarter and also all those things which are important for living. House h…	1813	MAC Estate & Builders	2602	Muhammad Ali, Muhammad Sufiyan, Muhammad Ali	PKR3.25 Crore\|
311673	162	https://www.zameen.com/Property/islamabad_f_10_fantastic_house_for_sale-311673-162-1.html	39	House	37000000	PKR3.7 Crore	F-10	31	Islamabad	31	Islamabad Capital	33.691531	73.005431	5	1 Kanal	29	For Sale	5	11-23-2021	An ideal house is available for sale. It is situated in Sector F-10, Islamabad. Its measuring area is 500 square yards and it is ideal for residential purpose. It has 5 bedrooms with attached bathrooms, beautiful lawn, servant quarter and also all those things which are important for living. House h…	1813	MAC Estate & Builders	2602	Muhammad Ali, Muhammad Sufiyan, Muhammad Ali	PKR3.7 Crore\|
311674	162	https://www.zameen.com/Property/islamabad_f_10_excellent_house_for_sale-311674-162-1.html	39	House	38000000	PKR3.8 Crore	F-10	31	Islamabad	31	Islamabad Capital	33.691531	73.005431	5	1 Kanal	29	For Sale	5	11-23-2021	An ideal house is available for sale. It is situated in Sector F-10, Islamabad. Its measuring area is 500 square yards and it is ideal for residential purpose. It has 5 bedrooms with attached bathrooms, beautiful lawn, servant quarter and also all those things which are important for living. House h…	1813	MAC Estate & Builders	2602	Muhammad Ali, Muhammad Sufiyan, Muhammad Ali	PKR3.8 Crore\|
311676	162	https://www.zameen.com/Property/islamabad_f_10_marvelous_house_for_sale-311676-162-1.html	39	House	44000000	PKR4.4 Crore	F-10	31	Islamabad	31	Islamabad Capital	33.691531	73.005431	5	1 Kanal	29	For Sale	6	11-23-2021	An ideal house is available for sale. It is situated in Sector F-10, Islamabad. Its measuring area is 500 square yards and it is ideal for residential purpose. It has 6 bedrooms with attached bathrooms, beautiful lawn, servant quarter and also all those things which are important for living. House h…	1813	MAC Estate & Builders	2602	Muhammad Ali, Muhammad Sufiyan, Muhammad Ali	PKR4.4 Crore\|
311678	162	https://www.zameen.com/Property/islamabad_f_10_ideal_house_for_sale-311678-162-1.html	39	House	48000000	PKR4.8 Crore	F-10	31	Islamabad	31	Islamabad Capital	33.691531	73.005431	5	1 Kanal	29	For Sale	6	11-23-2021	An ideal house is available for sale. It is situated in Sector F-10, Islamabad. Its measuring area is 500 square yards and it is ideal for residential purpose. It has 6 bedrooms with attached bathrooms, beautiful lawn, servant quarter and also all those things which are important for living. House h…	1813	MAC Estate & Builders	2602	Muhammad Ali, Muhammad Sufiyan, Muhammad Ali	PKR4.8 Crore\|
311681	163	https://www.zameen.com/Property/islamabad_f_11_six_beds_house_for_sale-311681-163-1.html	39	House	34000000	PKR3.4 Crore	F-11	31	Islamabad	31	Islamabad Capital	33.683532	72.99041	5	1 Kanal	29	For Sale	5	11-23-2021	An ideal house is available for sale. It is situated in Sector F-11, Islamabad. Its measuring area is 500 square yards and it is ideal for residential purpose. It has 6 bedrooms with attached bathrooms, beautiful lawn, servant quarter and also all those things which are important for living. House h…	1813	MAC Estate & Builders	2602	Muhammad Ali, Muhammad Sufiyan, Muhammad Ali	PKR3.4 Crore\|
311684	163	https://www.zameen.com/Property/islamabad_f_11_excellent_house_for_sale-311684-163-1.html	39	House	36000000	PKR3.6 Crore	F-11	31	Islamabad	31	Islamabad Capital	33.683532	72.99041	5	1 Kanal	29	For Sale	5	11-23-2021	An ideal house is available for sale. It is situated in Sector F-11, Islamabad. Its measuring area is 500 square yards and it is ideal for residential purpose. It has 6 bedrooms with attached bathrooms, beautiful lawn, servant quarter and also all those things which are important for living. House h…	1813	MAC Estate & Builders	2602	Muhammad Ali, Muhammad Sufiyan, Muhammad Ali	PKR3.6 Crore\|
311687	163	https://www.zameen.com/Property/islamabad_f_11_ideal_house_for_sale-311687-163-1.html	39	House	37000000	PKR3.7 Crore	F-11	31	Islamabad	31	Islamabad Capital	33.683532	72.99041	5	1 Kanal	29	For Sale	5	11-23-2021	An ideal house is available for sale. It is situated in Sector F-11, Islamabad. Its measuring area is 500 square yards and it is ideal for residential purpose. It has 6 bedrooms with attached bathrooms, beautiful lawn, servant quarter and also all those things which are important for living. House h…	1813	MAC Estate & Builders	2602	Muhammad Ali, Muhammad Sufiyan, Muhammad Ali	PKR3.7 Crore\|
311691	163	https://www.zameen.com/Property/islamabad_f_11_excellent_house_for_sale-311691-163-1.html	39	House	42500000	PKR4.25 Crore	F-11	31	Islamabad	31	Islamabad Capital	33.683532	72.99041	5	1 Kanal	29	For Sale	5	11-23-2021	An ideal house is available for sale. It is situated in Sector F-11, Islamabad. Its measuring area is 500 square yards and it is ideal for residential purpose. It has 6 bedrooms with attached bathrooms, beautiful lawn, servant quarter and also all those things which are important for living. House h…	1813	MAC Estate & Builders	2602	Muhammad Ali, Muhammad Sufiyan, Muhammad Ali	PKR4.25 Crore\|


CREATE TABLE property_details_tbl (
  "property_id" BIGINT,
  "location_id" BIGINT,
  "page_url" VARCHAR,
  "type_id" BIGINT,
  "n__type" VARCHAR,
  "price" BIGINT,
  "price_1" VARCHAR,
  "location" VARCHAR,
  "city_id" BIGINT,
  "city" VARCHAR,
  "province_id" BIGINT,
  "province" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "baths" BIGINT,
  "area" VARCHAR,
  "purpose_id" BIGINT,
  "n__purpose" VARCHAR,
  "bedrooms" BIGINT,
  "date_added" VARCHAR,
  "description" VARCHAR,
  "agency_id" VARCHAR,
  "n__agency" VARCHAR,
  "agent_id" VARCHAR,
  "n__agent" VARCHAR,
  "amenities" VARCHAR
);