Title Page Background
DEBUG FN args: Array ( [0] => 305 [1] => [2] => [3] => agent ) BEFORE: Site: 305 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 305 Igate: njhud LocID: 305 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 305 AND i.igate IN ('cohud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 305 [1] => [2] => [3] => lender ) BEFORE: Site: 305 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 305 Igate: njhud LocID: 305 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 305 AND i.igate IN ('cohud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 305 [1] => [2] => [3] => other ) BEFORE: Site: 305 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 305 Igate: njhud LocID: 305 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 305 AND i.igate IN ('cohud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

188 Calle De La Lluvia Drive
Florissant, CO 80816

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $739,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2800 Square Feet
Agency: Your Neighborhood Realty, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Style and Serenity come with this 2022 built home sitting on 2.54 acres. This alluring 2800 sq, foot house is a exceptional investment as a multi-general home or an Airbnb .The spacious main level is 1600 sq. feet with a Master Suite bedroom on the upper level with balcony and great views of Pikes Peak. Additional Master bedroom suite and 1 bedroom with attached bathrooms are on the main level. The gas fireplace adds ambience to the Living room and the views from every window are of Pikes Peak and have great passive solar gain. The kitchen has ample cabinets with granite counter tops and stainless steel appliances. The flooring consists of Wood Laminate for easy upkeep. The lower level has 2 bedrooms, laundry facilities , bath room, living room and also a ample cabinet kitchen with granite counter tops and stainless steel appliances. Great space for parents. Views are also of Pikes Peak. Plus there is a 480 sq foot 1 bedroom apartment in back of the garage with living room and propane stove, kitchen with stainless steel appliances, laundry facilities and a single car garage access. This space would be great for extended family. Three trex decks allow many options to enjoy the views and natural surroundings of the property .Family and friends can also gather on a 20x30 stamped concrete patio for out door grilling. Very private back yard with over a 100 Aspen Trees and a garden area for planting vegetables. Black top driveway and parking area. The front of the house also has a trex deck and a concrete patio to enjoy the views. This property is close to Teller 1 and convenient way to get to Cripple Creek. There are abundant recreational opportunities nearby.
MlsNumber: --


Listing Provided By: Your Neighborhood Realty, Inc., original listing
Phone: (719) 235-2409
Office Phone: (719) 235-2409
Agent Name: Rosa Peters
Disclaimer: Copyright © 2024 Pikes Peak Association of REALTORS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App