SELECT,, p.price,, p.address, p.bedroom_count, p.bathroom_count, p.square_feet, p.descr, i.medium_filename, i.medium_width, i.medium_height FROM properties AS p LEFT JOIN ( SELECT i1.property_id, i2.medium_filename, i2.medium_width, i2.medium_height FROM property_images AS i1 LEFT JOIN ( SELECT medium_filename, medium_width, medium_height, property_id FROM property_images ORDER BY ordernum ASC ) AS i2 ON (i1.property_id = i2.property_id) GROUP BY i1.property_id ) AS i ON ( = i.property_id) WHERE p.property_category_id = '4' ORDER BY p.ordernum Jim Irving - Lake Nacimiento Properties

Lake Nacimiento Properties

Scenic Lake Nacimiento Acreage


MLS: #1045473
Angus Ranch Road, Paso Robles, CA 93446

Scenic Lake Nacimiento Acreage! Unique, private, beautiful, all are appropriate descriptors for this stunning 24-acre property on the shores of Lake Nacimiento. Surrounded by Open Space lands...

More Photos & Info

10 Prime Lakefront Acres

$755,000 JUST REDUCED!!!

MLS: #1043405
3555 Acorn Lane, Paso Robles, CA 93446
Bath 1 Sqr. Ft. 3000

10 Prime Lakefront Acres! Experience Lake Nacimiento at its finest from this spectacular Ranchos del Lago property. The level, fenced acreage features majestic oaks and numerous improvements...

More Photos & Info

Lakefront Property at Running Deer


MLS: #177134
5585 Aluffo Road, Paso Robles, CA 93446-9744

Lakefront property at Lake Nacimiento! 9.96 +/- acres with great panoramic lake views in Running Deer Ranch.  There is a beautiful ridgetop building site with a vintage...

More Photos & Info

Scenic Site & Unblockable Views

$495,000 JUST REDUCED!!!

MLS: #1039143
0000 Smith Point Road, Bradley, CA 93426
Sqr. Ft. 380

Created before there was an Oak Shores, this unique 1.9-acre parcel is not subject to the restrictions of the development. The Seller states that the property...

More Photos & Info

Las Tablas Valley Vistas


6250 Round Corral Road, Paso Robles, CA 93446
Bed 0 Bath 3/4 Sqr. Ft. 2000

Las Tablas Valley Vistas! Discover Adelaide at its most beautiful with this seasonally lakefront parcel in Running Deer Ranch. The gorgeous 40-acre property features a 2000 sq...

More Photos & Info