query
RESULTSET
query
  ADDRESS ADTYPE AGENTID BANNER BATHS BEDROOMS BROKERID CITY CITYID COUNTYID DATEADDED DESCRIPTION DISPLAY FIREPLACES GARAGE GRABBER GRABBER2 IDENTIFIER LASTUPDATE LINK LISTINGID LOFT LOTSIZEUNIT LOT_SIZE L_STATE MLSID MLS_NUMBER NEWPHOTO OPENHOUSE OVERSIZED PAGENAME PRICE SCHOOLDIST SORTID SPECIALID SQ_FEET SQ_FEET_UNFIN SUBDIVISION TYPEID UNITNUM VTOUR YEARBUILT ZIP ZONEID ZONING
1 8338 W Rivulet 0 94023 UNDER CONTRACT! 2.10 2 39694 OTHER [empty string] 0 2023-11-22 07:32:35.0 modern urban home is ready to be occupied. As you walk into the home, you will be taken away by the uplifting natural light and modern architectural design. Built by Richmond Homes America in 2019. This two bedroom, two and half bathroom single family home provides elegance with ultra-modern features! This is truly a great community for friends and family for years to come. The main floor comes with a large gourmet kitchen, GE stainless steel appliances, Quartz Countertops, Maple Cabinets, electric cooktop, double oven, and a large walk in pantry on the main floor. As you make your way to the upper level, the primary suite and second bedroom are both on-set suites, to provide you with ultimate privacy. The rooftop deck is where you will be provided with the most breath taking views of the rocky mountains, and the city of Denver, Colorado. 1 [empty string] 2 Car Garage,Attached THIS ONE OF A KIND ULTRA OTHER $659,995 matrix_7428496 2024-01-18 11:25:13.0 kylecoy@nestseekers.com 574565 0 acres 0.039 CO 1 S1045064 [empty string] [empty string] 0 659995.0000 0 0 1800 0 OTHER 2 [empty string] [empty string] 2019 80129 0 Single Family
CACHED false
EXECUTIONTIME 0
SQL SELECT * from listing_info where listingid='574565'
THERE IS A PROBLEM WITH THIS LISTING AND THE WEBMASTER HAS BEEN NOTIFIED