USA Housing Listings

Homes for sale within the United States

@kaggle.austinreese_usa_housing_listings

Table List

1 table(166.29 MB)

Housing

@kaggle.austinreese_usa_housing_listings.housing

166.29 MB
384977 rows
22 columns

id Id	url Url	region Region	region_url Region Url	price Price	type Type	sqfeet Sqfeet	beds Beds	baths Baths	cats_allowed Cats Allowed	dogs_allowed Dogs Allowed	smoking_allowed Smoking Allowed	wheelchair_access Wheelchair Access	comes_furnished Comes Furnished	laundry_options Laundry Options	parking_options Parking Options	image_url Image Url	description Description	lat Lat	long Long	state State
7049044568	https://reno.craigslist.org/apa/d/reno-beautiful-3x2-newly-renovated/7049044568.html	reno / tahoe	https://reno.craigslist.org	1148	apartment	1078	3	2	1	1				w/d in unit	carport	https://images.craigslist.org/01616_daghmBUvTCI_600x450.jpg	Ridgeview by Vintage is where you will find all of your apartment living needs at a price you can afford! Our spacious homes are located just off the freeway for easy access to shopping and entertainment, as well as a short drive from all the wonderful outdoor activities that the Truckee Meadows ha…	39.5483	-119.796	ca
7049047186	https://reno.craigslist.org/apa/d/reno-reduced-lovely-2bd-2ba-condo/7049047186.html	reno / tahoe	https://reno.craigslist.org	1200	condo	1001	2	2						w/d hookups	carport	https://images.craigslist.org/00V0V_5va0MkgO9qu_600x450.jpg	Conveniently located in the middle town of Reno. Close to Highway, 10 mins to UNR, shopping and restaurants. Lovely 2 bedroom/2 full bathroom with walk-in closet. Central AC. Available Jan. Now. Please call show contact info for viewing.	39.5026	-119.789	ca
7043634882	https://reno.craigslist.org/apa/d/sparks-state-of-the-art-fitness-center/7043634882.html	reno / tahoe	https://reno.craigslist.org	1813	apartment	1683	2	2	1	1	1			w/d in unit	attached garage	https://images.craigslist.org/00t0t_erYqC6LgB8r_600x450.jpg	2BD \| 2BA \| 1683SQFTDiscover exceptional service and well-designed spacious floor plans at Caviata apartment homes in Sparks, Nevada. Our Kiley Ranch and Spanish Springs neighborhood pet friendly two and three-bedroom apartment homes feature fully equipped kitchens with expansive granite countertops…	39.6269	-119.708	ca
7049045324	https://reno.craigslist.org/apa/d/reno-1x1-first-floor-washer-dryer-no/7049045324.html	reno / tahoe	https://reno.craigslist.org	1095	apartment	708	1	1	1	1	1			w/d in unit	carport	https://images.craigslist.org/00303_3HSJz75zlIf_600x450.jpg	MOVE IN SPECIAL FREE WASHER/DRYER WITH 6 OR 12 MONTH LEASE! Ask about our preferred employer program for extra discounts! One bedroom/One bath 708 sq.ft. $1095 per month Deposit $400 1/2 refundable Specials and rates are subject to change at any time -Call us today at show contact info or sho…	39.4477	-119.771	ca
7049043759	https://reno.craigslist.org/apa/d/reno-no-long-term-lease-required/7049043759.html	reno / tahoe	https://reno.craigslist.org	289	apartment	250		1	1	1	1	1	1	laundry on site	nan	https://images.craigslist.org/01616_fALAWFV8zQN_600x450.jpg	Move In Today: Reno Low-Cost, Clean & Furnished Apartments close to Restaurants, Cafes, Parks, and More! Call Us! Move In Today! Available:Studio Units Short Term Flexible Options Utilities IncludedFully Furnished Free Basic Cable TV Call Now: show contact info Additional Information:www.s…	39.5357	-119.805	ca
7046327064	https://reno.craigslist.org/apa/d/reno-walk-in-closet-extra-storage/7046327064.html	reno / tahoe	https://reno.craigslist.org	1093	apartment	720	1	1	1	1	1			laundry in bldg	nan	https://images.craigslist.org/00808_1EfWoZv4NXC_600x450.jpg	1BD \| 1BA \| 720SQFTIn addition to attractive, comfortable apartments, Village at Iron Blossom combines all that Reno has to offer in one well-rounded community. We feature spacious one, two, and three bedroom oversized apartment homes where you'll find the style that matches the look and life you de…	39.4572	-119.776	ca
7049020738	https://reno.craigslist.org/apa/d/1-bedroom-available-in-midtown/7049020738.html	reno / tahoe	https://reno.craigslist.org	935	apartment	661	1	1	1	1	1			laundry on site	off-street parking	https://images.craigslist.org/00C0C_i1DJWxfSZC6_600x450.jpg	Tucked away in a park-like setting on the edge of midtown, located just minutes from shopping, restaurants. Charming updated Apartment with Free wifi, on sight laundry, assigned parking and off street parking. Pets are always welcome up to 25 lbs. The unit coming available is located on the 2nd flo…	39.5118	-119.802	ca
7049041899	https://reno.craigslist.org/apa/d/reno-1x1-first-floor-washer-dryer-no/7049041899.html	reno / tahoe	https://reno.craigslist.org	1095	apartment	708	1	1	1	1	1			w/d in unit	carport	https://images.craigslist.org/00303_3HSJz75zlIf_600x450.jpg	MOVE IN SPECIAL FREE WASHER/DRYER WITH 6 OR 12 MONTH LEASE! Ask about our preferred employer program for extra discounts! One bedroom/One bath 708 sq.ft. $1095 per month Deposit $400 1/2 refundable Specials and rates are subject to change at any time -Call us today at show contact info or sho…	39.4477	-119.771	ca
7049041451	https://reno.craigslist.org/apa/d/sparks-boutique-property-in-the-heart/7049041451.html	reno / tahoe	https://reno.craigslist.org	1525	apartment	1053	2	2	1	1				w/d in unit	carport	https://images.craigslist.org/00W0W_aMt5LvqkQht_600x450.jpg	BRAND NEW APARTMENT HOMES, NOW OPEN! GET 1 MONTH FREE AND WAIVED APPLICATION AND ADMIN FEES!! O.A.C when you sign a 12-month lease** Silverado Apartments 7077 Vista Blvd Sparks, NV 89436 You could be living in the heart of Wingfield Springs. Silverado is your newest luxury community featurin…	39.6185	-119.672	ca
7049041434	https://reno.craigslist.org/apa/d/reno-6850-sharlands-ave-1021/7049041434.html	reno / tahoe	https://reno.craigslist.org	1295	condo	930	2	2						w/d in unit	carport	https://images.craigslist.org/01313_8AoC9NJZWAx_600x450.jpg	6850 Sharlands Ave E-1021 Reno NV 89523 Property Address 6850 Sharlands Avenue E-1021 \| Reno, NV 89523 Available: 02/07/2020 Offered By Dickson Realty, Inc. \| show contact info Description Charming two bedroom, two full bath condo will be available approximately…	39.5193	-119.897	ca


CREATE TABLE housing (
  "id" BIGINT,
  "url" VARCHAR,
  "region" VARCHAR,
  "region_url" VARCHAR,
  "price" BIGINT,
  "type" VARCHAR,
  "sqfeet" BIGINT,
  "beds" BIGINT,
  "baths" DOUBLE,
  "cats_allowed" BIGINT,
  "dogs_allowed" BIGINT,
  "smoking_allowed" BIGINT,
  "wheelchair_access" BIGINT,
  "electric_vehicle_charge" BIGINT,
  "comes_furnished" BIGINT,
  "laundry_options" VARCHAR,
  "parking_options" VARCHAR,
  "image_url" VARCHAR,
  "description" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "state" VARCHAR
);