Listing Agent: Dante Delapaz Garcia, Re/Max Pines by the Sea
Welcome to this delightfully peaceful Cambria home with 4 Parcel Numbers totaling 7 lots. 14,248 sq feet of tranquil, space to forget your busy day and protect your forest views from the back deck. This home features a front and a back deck with access from the living room to enjoy the chirping birds on the outdoors. Be swept away by the street to street taste of nature, in this tranquil neighborhood just about 3 minutes from the amazing Cambria beach and Fiscalini Ranch Preserve. Vaulted ceilings, fire place, a convenient layout, fire pit, fenced yard are just a few of the many features of this magnificent property. Lot's of natural light comes in from the sliding doors and multiple windows. Call your agent before this beautiful home is gone.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1988
Year Built Source
Other
Special Listing Conditions
Standard, Trust
Stories Total
2
Levels
Two
Number Of Units Total
1
Entry Level
2
Entry Location
Front
Price Per Square Foot
$735
Days On Market
248
Cumulative Days On Market
248
County Or Parish
San Luis Obispo
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Fence Y/N
Yes
Heating Y/N
Yes
Directions
Driving North on HW1 turn left on Ardath, left on Haddon Dr, right on Tweed Ave, left on Dreydon Ave
Room Type
Living Room
Heating
Forced Air
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
In Garage
Roof
Shingle
Other Structures
Storage
Main Level Bedrooms
1
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Bathrooms Half
1
Main Level Bathrooms
2
Room Kitchen Features
Tile Counters
Eating Area
Dining Room
Appliances Y/N
Yes
Appliances
Gas Range, Refrigerator, Water Heater
Interior Features
Balcony
Flooring
Laminate
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Living Room, Gas
Pool Features
None
Pool Private Y/N
No
Spa Y/N
No
Spa Features
None
Patio Y/N
Yes
Patio And Porch Features
Deck, Patio
Utilities
Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Parking Y/N
Yes
Parking Total
2.00
Parking Features
Driveway, Garage
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
0-1 Unit/Acre
Lot Size Area
14248.0000
Lot Size Units
Square Feet
Lot Size Dimensions
14248
Road Surface Type
Paved
View Y/N
Yes
View
Mountain(s), Trees/Woods
Fencing
Wood
Common Interest
None
Parcel Number
023391041
Additional Parcels Y/N
No
Additional Parcels Description
023391009, 023391018, 023391027
Zoning
RSF
Subdivision Name
Lodge Hill(430)
Subdivision Name Other
Lodge Hill(430)
Community Features
Biking, Dog Park, Fishing, Hiking, Gutters, Park
Senior Community Y/N
No
Association Y/N
No
High School District
Coast Unified
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
42
Tax Census Tract
104.03
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 916750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1013250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1063 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1563 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1701471 OR `props-main`.`id` = 1692233 OR `props-main`.`id` = 1696234 OR `props-main`.`id` = 1679063 OR `props-main`.`id` = 1623435 OR `props-main`.`id` = 1686664 OR `props-main`.`id` = 1695429 OR `props-main`.`id` = 1680388 OR `props-main`.`id` = 1689098 OR `props-main`.`id` = 1623331 OR `props-main`.`id` = 1696571 OR `props-main`.`id` = 1623354 OR `props-main`.`id` = 1623384 OR `props-main`.`id` = 1666559 OR `props-main`.`id` = 1686887 OR `props-main`.`id` = 1678374 OR `props-main`.`id` = 1635092 OR `props-main`.`id` = 1686646 OR `props-main`.`id` = 1658787 OR `props-main`.`id` = 1683860 OR `props-main`.`id` = 1692232 OR `props-main`.`id` = 1692095 OR `props-main`.`id` = 1683861 OR `props-main`.`id` = 1662233 OR `props-main`.`id` = 1696072 OR `props-main`.`id` = 1623308 OR `props-main`.`id` = 1638830 OR `props-main`.`id` = 1663284 OR `props-main`.`id` = 1678611 OR `props-main`.`id` = 1684502 OR `props-main`.`id` = 1683859 OR `props-main`.`id` = 1685443 OR `props-main`.`id` = 1683858 OR `props-main`.`id` = 1692546 OR `props-main`.`id` = 1680741 OR `props-main`.`id` = 1689135 OR `props-main`.`id` = 1650063 OR `props-main`.`id` = 1678678 OR `props-main`.`id` = 1695227 OR `props-main`.`id` = 1696961 OR `props-main`.`id` = 1623330 OR `props-main`.`id` = 1623333 OR `props-main`.`id` = 1694419 OR `props-main`.`id` = 1680803 OR `props-main`.`id` = 1683857 OR `props-main`.`id` = 1656566 OR `props-main`.`id` = 1676382 OR `props-main`.`id` = 1688620 OR `props-main`.`id` = 1697849 OR `props-main`.`id` = 1654369 OR `props-main`.`id` = 1684624 OR `props-main`.`id` = 1623382 OR `props-main`.`id` = 1623454 OR `props-main`.`id` = 1701337 OR `props-main`.`id` = 1694385 OR `props-main`.`id` = 1696235 OR `props-main`.`id` = 1691920 OR `props-main`.`id` = 1683862 OR `props-main`.`id` = 1679376 OR `props-main`.`id` = 1679377 OR `props-main`.`id` = 1645717 OR `props-main`.`id` = 1680341 OR `props-main`.`id` = 1680714 OR `props-main`.`id` = 1689711 OR `props-main`.`id` = 1695431 OR `props-main`.`id` = 1696091 OR `props-main`.`id` = 1615049 OR `props-main`.`id` = 1623314 OR `props-main`.`id` = 1691955 OR `props-main`.`id` = 1614985 OR `props-main`.`id` = 1659370 OR `props-main`.`id` = 1673471 OR `props-main`.`id` = 1697863 OR `props-main`.`id` = 1606104 OR `props-main`.`id` = 1623464 OR `props-main`.`id` = 1697861 OR `props-main`.`id` = 1697862 OR `props-main`.`id` = 1697864 OR `props-main`.`id` = 1657721 OR `props-main`.`id` = 1693909 OR `props-main`.`id` = 1623520 OR `props-main`.`id` = 1697865 OR `props-main`.`id` = 1700062 OR `props-main`.`id` = 1623374 OR `props-main`.`id` = 1623341 OR `props-main`.`id` = 1697855 OR `props-main`.`id` = 1623339 OR `props-main`.`id` = 1673922 OR `props-main`.`id` = 1623179 OR `props-main`.`id` = 1685474 OR `props-main`.`id` = 1684530 OR `props-main`.`id` = 1698744 OR `props-main`.`id` = 1637999 OR `props-main`.`id` = 1699188 OR `props-main`.`id` = 1700092 OR `props-main`.`id` = 1697288 OR `props-main`.`id` = 1623334 OR `props-main`.`id` = 1681415 OR `props-main`.`id` = 1623498 OR `props-main`.`id` = 1681186 OR `props-main`.`id` = 1696938 OR `props-main`.`id` = 1623321 OR `props-main`.`id` = 1693443 OR `props-main`.`id` = 1686025 OR `props-main`.`id` = 1690475 OR `props-main`.`id` = 1690042 OR `props-main`.`id` = 1660475 OR `props-main`.`id` = 1660474 OR `props-main`.`id` = 1681528 OR `props-main`.`id` = 1662548 OR `props-main`.`id` = 1671625 OR `props-main`.`id` = 1623328 OR `props-main`.`id` = 1694514)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsSC25087795' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-06' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
0
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
