Listing Agent: MELISSA WESTFALL, OPENDOOR BROKERAGE INC.
Picture yourself at 5259 Hillcrest Dr, a residence arranged for everyday comfort with a convenient flow. A cozy fireplace provides warmth and ambiance. The kitchen features all stainless steel appliances complemented by an accent backsplash. The primary bathroom provides practicality with double sinks. Outside, a spacious deck overlooks a fully fenced in backyard. Experience a blend of comfort and functional design in this exceptional home.. Included 100-Day Home Warranty with buyer activation
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1967
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Entry Location
Ground Level
Price Per Square Foot
$580
Days On London
0
Cumulative Days On London
0
County Or Parish
San Luis Obispo
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Head toward CA-1 N. Turn right onto Main St. Turn left onto Pineknolls Dr. Turn right onto Hartford St. Turn left to stay on Hartford St. Turn left onto Oakhurst Dr. Turn right at the 1st cross street onto Hillcrest Dr
Disclosures
LA/Owner Related
Room Type
Kitchen
Heating
Natural Gas
Cooling
Electric, Central Air
Laundry Y/N
Yes
Laundry Features
Washer Hookup
Roof
Shingle, Asphalt
Construction Materials
Wood Siding, Brick
Main Level Bedrooms
0
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Main Level Bathrooms
0
Appliances Y/N
Yes
Appliances
Dishwasher
Accessibility Features
None
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Gas
Pool Features
None
Pool Private Y/N
No
Water Source
Public
Sewer
Public Sewer
Parking Y/N
Yes
Parking Total
2.00
Parking Features
Garage
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Desert Front
Lot Size Area
10800.0000
Lot Size Units
Square Feet
View Y/N
No
View
None
Common Interest
None
Parcel Number
013311009
Additional Parcels Y/N
No
Subdivision Name
Other (OTHR)
Subdivision Name Other
Other
Community Features
Sidewalks
Senior Community Y/N
No
Association Y/N
No
High School District
Coast Unified
Elementary School
Cambria
Middle Or Junior School
Santa Lucia
High School
Coast Union
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
0
Tax Tract Number
112
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1045000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1155000 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) >= 1645 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2145 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` = 1692233 OR `props-main`.`id` = 1725817 OR `props-main`.`id` = 1717437 OR `props-main`.`id` = 1623435 OR `props-main`.`id` = 1732642 OR `props-main`.`id` = 1726483 OR `props-main`.`id` = 1686664 OR `props-main`.`id` = 1721784 OR `props-main`.`id` = 1716860 OR `props-main`.`id` = 1715036 OR `props-main`.`id` = 1623331 OR `props-main`.`id` = 1696571 OR `props-main`.`id` = 1716893 OR `props-main`.`id` = 1728863 OR `props-main`.`id` = 1623354 OR `props-main`.`id` = 1732740 OR `props-main`.`id` = 1623384 OR `props-main`.`id` = 1666559 OR `props-main`.`id` = 1717677 OR `props-main`.`id` = 1678374 OR `props-main`.`id` = 1635092 OR `props-main`.`id` = 1732837 OR `props-main`.`id` = 1686646 OR `props-main`.`id` = 1727376 OR `props-main`.`id` = 1728010 OR `props-main`.`id` = 1704609 OR `props-main`.`id` = 1683860 OR `props-main`.`id` = 1692232 OR `props-main`.`id` = 1702692 OR `props-main`.`id` = 1733208 OR `props-main`.`id` = 1683861 OR `props-main`.`id` = 1662233 OR `props-main`.`id` = 1732836 OR `props-main`.`id` = 1720756 OR `props-main`.`id` = 1623308 OR `props-main`.`id` = 1715717 OR `props-main`.`id` = 1684502 OR `props-main`.`id` = 1719212 OR `props-main`.`id` = 1683859 OR `props-main`.`id` = 1685443 OR `props-main`.`id` = 1728345 OR `props-main`.`id` = 1683858 OR `props-main`.`id` = 1680741 OR `props-main`.`id` = 1689135 OR `props-main`.`id` = 1726784 OR `props-main`.`id` = 1678678 OR `props-main`.`id` = 1707099 OR `props-main`.`id` = 1695227 OR `props-main`.`id` = 1708428 OR `props-main`.`id` = 1717408 OR `props-main`.`id` = 1701471 OR `props-main`.`id` = 1702074 OR `props-main`.`id` = 1623330 OR `props-main`.`id` = 1623333 OR `props-main`.`id` = 1732244 OR `props-main`.`id` = 1727305 OR `props-main`.`id` = 1716981 OR `props-main`.`id` = 1680803 OR `props-main`.`id` = 1713385 OR `props-main`.`id` = 1683857 OR `props-main`.`id` = 1716934 OR `props-main`.`id` = 1676382 OR `props-main`.`id` = 1697849 OR `props-main`.`id` = 1723851 OR `props-main`.`id` = 1654369 OR `props-main`.`id` = 1684624 OR `props-main`.`id` = 1728016 OR `props-main`.`id` = 1623382 OR `props-main`.`id` = 1707241 OR `props-main`.`id` = 1728193 OR `props-main`.`id` = 1715618 OR `props-main`.`id` = 1705320 OR `props-main`.`id` = 1722387 OR `props-main`.`id` = 1701337 OR `props-main`.`id` = 1731899 OR `props-main`.`id` = 1720247 OR `props-main`.`id` = 1720246 OR `props-main`.`id` = 1731139 OR `props-main`.`id` = 1731898 OR `props-main`.`id` = 1712964 OR `props-main`.`id` = 1709224 OR `props-main`.`id` = 1683862 OR `props-main`.`id` = 1727043 OR `props-main`.`id` = 1724170 OR `props-main`.`id` = 1716927 OR `props-main`.`id` = 1716365 OR `props-main`.`id` = 1729220 OR `props-main`.`id` = 1717678 OR `props-main`.`id` = 1723026 OR `props-main`.`id` = 1702959 OR `props-main`.`id` = 1623314 OR `props-main`.`id` = 1716521 OR `props-main`.`id` = 1691955 OR `props-main`.`id` = 1614985 OR `props-main`.`id` = 1716270 OR `props-main`.`id` = 1657721 OR `props-main`.`id` = 1623520 OR `props-main`.`id` = 1722501 OR `props-main`.`id` = 1697865 OR `props-main`.`id` = 1725659 OR `props-main`.`id` = 1726260 OR `props-main`.`id` = 1727783 OR `props-main`.`id` = 1623374 OR `props-main`.`id` = 1712962 OR `props-main`.`id` = 1727893 OR `props-main`.`id` = 1623339 OR `props-main`.`id` = 1723323 OR `props-main`.`id` = 1685474 OR `props-main`.`id` = 1719964 OR `props-main`.`id` = 1698744 OR `props-main`.`id` = 1637999 OR `props-main`.`id` = 1699188 OR `props-main`.`id` = 1723396 OR `props-main`.`id` = 1700062 OR `props-main`.`id` = 1718555 OR `props-main`.`id` = 1623334 OR `props-main`.`id` = 1716928 OR `props-main`.`id` = 1623498 OR `props-main`.`id` = 1725971 OR `props-main`.`id` = 1735815 OR `props-main`.`id` = 1696938 OR `props-main`.`id` = 1723367 OR `props-main`.`id` = 1690042 OR `props-main`.`id` = 1723699 OR `props-main`.`id` = 1723700 OR `props-main`.`id` = 1660475 OR `props-main`.`id` = 1660474 OR `props-main`.`id` = 1717299 OR `props-main`.`id` = 1662548 OR `props-main`.`id` = 1671625 OR `props-main`.`id` = 1623328 OR `props-main`.`id` = 1719218 OR `props-main`.`id` = 1719817 OR `props-main`.`id` = 1705895 OR `props-main`.`id` = 1713011 OR `props-main`.`id` = 1658009 OR `props-main`.`id` = 1713151 OR `props-main`.`id` = 1719620)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsIV26126194' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-10' 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.
