Title Page Background
DEBUG FN args: Array ( [0] => 3332 [1] => [2] => [3] => agent ) BEFORE: Site: 3332 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3332 Igate: njhud LocID: 3332 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 = 3332 AND i.igate IN ('inhud','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 = 'inhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3332 [1] => [2] => [3] => lender ) BEFORE: Site: 3332 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3332 Igate: njhud LocID: 3332 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 = 3332 AND i.igate IN ('inhud','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 = 'inhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3332 [1] => [2] => [3] => other ) BEFORE: Site: 3332 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3332 Igate: njhud LocID: 3332 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 = 3332 AND i.igate IN ('inhud','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 = 'inhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

59905 Avenida La Cumbre
Mountain Center, CA 92561

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $777,000
Beds: 3
Baths:
Status: Active
SqFt: 4852 Square Feet
Agency: Nova Real Estate Services

Map Details Show Map | Show StreetView




House Features

Appliances: Cooktop, Refrigerator, Cooktop - Electric
Architectural Style: Modern
Flooring: Carpet, Tile
Heating: Central Furnace
Interior Features: None, Storage, Ceiling Fan(s), Recessed Lighting, Balcony
Rooms: Office, Basement, Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bedroom 1, Bedroom 2, Bedroom 3, Kitchen, Laundry, Living Room

Window Features

Exterior Features: Corner Lot, Rural, Horse Property, Yard, Mountainous, Community Features Included: Hiking
Parking Features: Garage, Paved or Surfaced, Driveway, RV
View: Mountain, City

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: Chapman Ranchos Inc (32602)

Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1992
Notes: Seller is moving to the desert and open to a trade! Beautiful home up on the hill with exquisite views of the valley. Come experience the vibe and escape the heat. Only a short 20 min drive down to the valley floor for dinning or grocery shopping. Sitting on 2.37 acres you have plenty of room for whatever you desire. No HOA. Could potentially be great Airbnb. This home is located right off the pavement behind the shared gate of Chapman Ranchos, between Pinyon crest and Royal Carrizo. The minute you step through the door walk you feel a sense of warmth, with this large open concept floor plan with immaculate vistas in every direction. The large living room is a great place for entertaining, taking in the amazing views, or soaking up the cozy warmth of the fire place. There is a generous size open concept kitchen with attached dinning room. All bedrooms are conveniently located upstairs. The main-bedroom has dual walk in closet and a ensuite bathroom. There is room for a second laundry room with a separate entrance located off the main bedroom. The two other bedrooms upstairs both have attached bathrooms. The office located off the third bedroom has French doors for privacy with immaculate views making it difficult to get any work done. Downstairs the sellers took great pride in finishing the basement. One thing the home does not fall short of is storage. Two rooms downstairs are currently being used just for storage purposes. There is separate laundry room with Electric dryer and washer. An upgraded mud room for winter muddy days. Two additional finished rooms downstairs could be potentially used as bedrooms. The bathroom downstairs was just recently updated with a new shower, new glass shower door, and vanity. A large second living room downstairs has pool table, and the potential to add a full size kitchen. The attached two car garage being used as a gym. Curb appeal with paver stone driveway and walk way up to the house is finished too impress. The fresh exterior paint is an added plus. RV hook ups for any guest. Brand new water filtration system, all new toilets in all bathrooms, all new faucets, two new water heaters, recessed lighting throughout, newer carpet, freshly painted interior, finished basement with kitchen hook ups. Community has shared private water wells, and gate. Live the country life without being too far away from the city. Check out the 3D tour.
MlsNumber: --


Listing Provided By: Nova Real Estate Services, original listing
Phone: (760) 574-3915
Office Phone: (949) 273-8555
Agent Name: Jessica McAnallen
Disclaimer: Copyright © 2024 California Regional Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => riverside-east [3] => CA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: riverside-east State: CA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: riverside-east State: CA 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 = 3332 AND i.igate IN ('inhud','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 = 'inhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Tara Johansson, Lic#02129277
Tara Johansson, Lic#02129277
ASCIIColdwell Banker Realty
Call Today!: (949) 735-9784

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App