Listing Agent: Ron Mullins Jr., RE/MAX Parkside Real Estate
Beautiful brand new Harrod built home on a useable 20,000 square foot lot. This unbelievable home offers a 3 bedroom 3 bath home with an additional 1 bedroom 1 bath ADU. The ADU can be incorporated into the main home or kept as a stand alone unit. As always, the Harrod quality and attention to detail can be seen throughout this property. Some of the features include, luxury vinyl flooring throughout the entire home, shaker style cabinets, quartz counter tops, 10' ceilings, 8' doors, stainless steel appliances, brick wall feature in dining room, paid/owned solar and many many more. Property is fenced with white vinyl fencing including a 10' gate to allow for potential RV parking. The rear yard is a blank canvas and offers plenty of room for a pool, shop or whatever you desire. Front yard landscaping will be installed as soon as the weather allows. New homes on lots of this size are very rare and this is an excellent opportunity to own a home in town on a large useable lot. Home is ready for immediate occupancy. Do not miss the chance to see and purchase this amazing property!
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2024
Year Built Source
Seller
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
2
Entry Level
1
Entry Location
Front
Price Per Square Foot
$442
Days On Market
216
Cumulative Days On Market
665
County Or Parish
San Luis Obispo
New Construction Y/N
Yes
Property Attached Y/N
No
Cooling Y/N
Yes
Fence Y/N
Yes
Directions
Union Road to Prospect. Follow private drive to home.
Architectural Style
Traditional
Room Type
All Bedrooms Down, Entry, Great Room, Guest/Maid's Quarters, Kitchen, Laundry, Main Floor Bedroom, Main Floor Primary Bedroom, Primary Bathroom, Primary Bedroom, Primary Suite, Walk-In Closet
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Individual Room
Roof
Composition
Construction Materials
Brick Veneer, Stucco
Direction Faces
West
Window Features
Double Pane Windows
Foundation Details
Slab
Property Condition
Turnkey, Under Construction
Main Level Bedrooms
4
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Bathrooms Half
1
Main Level Bathrooms
4
Interior Features
Ceiling Fan(s), High Ceilings, Pantry, Quartz Counters
Level with Street, Lot 20000-39999 Sqft, Rectangular Lot, Level
Lot Size Area
20000.0000
Lot Size Units
Square Feet
Road Frontage Type
City Street, Private Road
Road Surface Type
Paved
View Y/N
No
View
None
Fencing
Vinyl
Common Interest
None
Parcel Number
025403077
Additional Parcels Y/N
No
Subdivision Name
PR City Limits East(110)
Subdivision Name Other
PR City Limits East(110)
Community Features
Sidewalks, Street Lights
Senior Community Y/N
No
Association Y/N
No
High School District
Paso Robles Joint Unified
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1139050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1258950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2462 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2962 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` = 1685873 OR `props-main`.`id` = 1696263 OR `props-main`.`id` = 1694601 OR `props-main`.`id` = 1696169 OR `props-main`.`id` = 1676679 OR `props-main`.`id` = 1678127 OR `props-main`.`id` = 1684112 OR `props-main`.`id` = 1695459 OR `props-main`.`id` = 1695460 OR `props-main`.`id` = 1695599 OR `props-main`.`id` = 1695602 OR `props-main`.`id` = 1696380 OR `props-main`.`id` = 1696127 OR `props-main`.`id` = 1697902 OR `props-main`.`id` = 1688976 OR `props-main`.`id` = 1696255 OR `props-main`.`id` = 1688284 OR `props-main`.`id` = 1696516 OR `props-main`.`id` = 1664392 OR `props-main`.`id` = 1697826 OR `props-main`.`id` = 1692579 OR `props-main`.`id` = 1697726 OR `props-main`.`id` = 1690873 OR `props-main`.`id` = 1623058 OR `props-main`.`id` = 1697404 OR `props-main`.`id` = 1686838 OR `props-main`.`id` = 1679353 OR `props-main`.`id` = 1694900 OR `props-main`.`id` = 1696614 OR `props-main`.`id` = 1679488 OR `props-main`.`id` = 1650747 OR `props-main`.`id` = 1628031 OR `props-main`.`id` = 1696128 OR `props-main`.`id` = 1640741 OR `props-main`.`id` = 1695865 OR `props-main`.`id` = 1683273 OR `props-main`.`id` = 1649719 OR `props-main`.`id` = 1693862 OR `props-main`.`id` = 1695995 OR `props-main`.`id` = 1677220 OR `props-main`.`id` = 1623065 OR `props-main`.`id` = 1658232 OR `props-main`.`id` = 1655096 OR `props-main`.`id` = 1695416 OR `props-main`.`id` = 1692459 OR `props-main`.`id` = 1697306 OR `props-main`.`id` = 1689183 OR `props-main`.`id` = 1696208 OR `props-main`.`id` = 1692468 OR `props-main`.`id` = 1623078 OR `props-main`.`id` = 1623077 OR `props-main`.`id` = 1623248 OR `props-main`.`id` = 1441090 OR `props-main`.`id` = 1623256 OR `props-main`.`id` = 1623254 OR `props-main`.`id` = 1674417 OR `props-main`.`id` = 1691926 OR `props-main`.`id` = 1684784 OR `props-main`.`id` = 1688676 OR `props-main`.`id` = 1689003 OR `props-main`.`id` = 1697308 OR `props-main`.`id` = 1696592 OR `props-main`.`id` = 1689037 OR `props-main`.`id` = 1679725 OR `props-main`.`id` = 1696746 OR `props-main`.`id` = 1696730 OR `props-main`.`id` = 1696744 OR `props-main`.`id` = 1696745 OR `props-main`.`id` = 1655027)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsNS25074345' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-16' 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.
