Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/crmls/PI26163649/154-Windward/Pismo-Beach/https://www.londonproperties.com/images/props/crmls/full/PI26163649.jpgLondon Properties Pismo Beach Real Estate | 154 Windward
Custom-built with exceptional craftsmanship, this stunning 3-bedroom, 3-bath residence offers breathtaking panoramic ocean views from an expansive rooftop deck. Designed with an open-concept floor plan, the home seamlessly blends indoor and outdoor living, creating the perfect setting for entertaining or relaxing. Located in the highly sought-after Village of Shell Beach, the home features a gourmet chef's kitchen with custom cement countertops, premium appliances, and quality finishes throughout. Radiant heated floors provide year-round comfort, while the attached two-car garage adds convenience and valuable storage. Thoughtful design, upscale amenities, and an exceptional coastal location make this a truly remarkable Shell Beach retreat.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2007
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
2
Levels
Two
Number Of Units Total
1
Entry Level
1
Entry Location
Down
Price Per Square Foot
$823
Days On London
20
Cumulative Days On London
20
County Or Parish
San Luis Obispo
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
No
Directions
Shell Beach Rd. turn on windward
Room Type
Walk-In Pantry, Laundry, Kitchen, Living Room, Family Room
Cooling
None
Laundry Y/N
Yes
Laundry Features
Inside, Gas Dryer Hookup, Washer Hookup
Main Level Bedrooms
2
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Bathrooms Half
1
Main Level Bathrooms
1
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Family Room
Pool Features
None
Pool Private Y/N
No
Water Source
Public
Sewer
Public Sewer
Parking Total
2.00
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Landscaped, Front Yard, Back Yard
Lot Size Area
3450.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Ocean, Hills, Panoramic
Common Interest
None
Parcel Number
010371008
Additional Parcels Y/N
No
Community Features
Biking, Street Lights
Senior Community Y/N
No
Association Y/N
No
High School District
Lucia Mar Unified
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
None
Tax Lot
6
Tax Tract Number
24
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1804050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1993950 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) >= 2058 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2558 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` = 1713687 OR `props-main`.`id` = 1724198 OR `props-main`.`id` = 1723357 OR `props-main`.`id` = 1719754 OR `props-main`.`id` = 1723365 OR `props-main`.`id` = 1738259 OR `props-main`.`id` = 1743919 OR `props-main`.`id` = 1762673 OR `props-main`.`id` = 1761808 OR `props-main`.`id` = 1679833 OR `props-main`.`id` = 1726797 OR `props-main`.`id` = 1717082 OR `props-main`.`id` = 1734750 OR `props-main`.`id` = 1726681 OR `props-main`.`id` = 1746387 OR `props-main`.`id` = 1747199 OR `props-main`.`id` = 1749194 OR `props-main`.`id` = 1751321 OR `props-main`.`id` = 1758363 OR `props-main`.`id` = 1722309 OR `props-main`.`id` = 1754379 OR `props-main`.`id` = 1723906 OR `props-main`.`id` = 1747201 OR `props-main`.`id` = 1723369 OR `props-main`.`id` = 1752268 OR `props-main`.`id` = 1732455 OR `props-main`.`id` = 1753273 OR `props-main`.`id` = 1756097 OR `props-main`.`id` = 1728344 OR `props-main`.`id` = 1761490 OR `props-main`.`id` = 1742762 OR `props-main`.`id` = 1740559 OR `props-main`.`id` = 1740560 OR `props-main`.`id` = 1689439 OR `props-main`.`id` = 1752224 OR `props-main`.`id` = 1743744 OR `props-main`.`id` = 1749435)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsPI26163649' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-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.
