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/PI25218918/171-Brook/San-Luis-Obispo/https://www.londonproperties.com/images/props/crmls/full/PI25218918.jpgLondon Properties San Luis Obispo Real Estate | 171 Brook
Great Investment Opportunity! Don't miss this clean, light-filled 3 bed, 1.75 bath home in a prime San Luis Obispo location! Features include hardwood flooring as well as tile flooring throughout the kitchen area and French doors that open to a covered patio and a beautifully shaded backyard with mature landscaping. The property also includes two spacious detached structures with finished interiors, windows, and electricity-ideal for use as an art studio, workshop, or extra storage (buyer to verify permitted uses). Charming SLO Home with Versatile Detached Spaces. An outdoor laundry area adds convenience. Located just minutes from downtown shops, restaurants, and nightlife, and close to Cal Poly. A great opportunity for investors or first-time buyers!
Cable Available, Electricity Connected, Natural Gas Connected, Phone Available, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Parking Y/N
Yes
Parking Features
Shared Driveway
Lot Features
Back Yard, Front Yard, Level with Street
Lot Size Area
3320.0000
Lot Size Units
Square Feet
Road Frontage Type
City Street
Road Surface Type
Paved
View Y/N
Yes
View
Neighborhood
Fencing
Excellent Condition
Common Interest
None
Parcel Number
004742006
Additional Parcels Y/N
No
Subdivision Name
San Luis Obispo(380)
Subdivision Name Other
San Luis Obispo(380)
Community Features
Biking, Dog Park, Fishing, Foothills, Golf, Hiking, Park, Street Lights
Senior Community Y/N
No
Association Y/N
No
High School District
San Luis Coastal Unified
High School
San Luis Obispo
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) >= 693500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 766500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 794 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1294 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` = 1673317 OR `props-main`.`id` = 1685333 OR `props-main`.`id` = 1685334 OR `props-main`.`id` = 1683594 OR `props-main`.`id` = 1685282 OR `props-main`.`id` = 1693760 OR `props-main`.`id` = 1697002 OR `props-main`.`id` = 1700931 OR `props-main`.`id` = 1685952 OR `props-main`.`id` = 1700898 OR `props-main`.`id` = 1656779 OR `props-main`.`id` = 1676256 OR `props-main`.`id` = 1668328 OR `props-main`.`id` = 1680645 OR `props-main`.`id` = 1649797 OR `props-main`.`id` = 1695010 OR `props-main`.`id` = 1695430 OR `props-main`.`id` = 1674938 OR `props-main`.`id` = 1696617 OR `props-main`.`id` = 1698094 OR `props-main`.`id` = 1690590 OR `props-main`.`id` = 1677935 OR `props-main`.`id` = 1696414 OR `props-main`.`id` = 1686681 OR `props-main`.`id` = 1688182 OR `props-main`.`id` = 1695021 OR `props-main`.`id` = 1690705 OR `props-main`.`id` = 1668175 OR `props-main`.`id` = 1697961 OR `props-main`.`id` = 1698710 OR `props-main`.`id` = 1623404 OR `props-main`.`id` = 1697318 OR `props-main`.`id` = 1697384 OR `props-main`.`id` = 1634854 OR `props-main`.`id` = 1694997 OR `props-main`.`id` = 1697216 OR `props-main`.`id` = 1694169 OR `props-main`.`id` = 1683352 OR `props-main`.`id` = 1685789 OR `props-main`.`id` = 1689688 OR `props-main`.`id` = 1689004 OR `props-main`.`id` = 1686820 OR `props-main`.`id` = 1690389 OR `props-main`.`id` = 1690508 OR `props-main`.`id` = 1686324 OR `props-main`.`id` = 1697934 OR `props-main`.`id` = 1682120 OR `props-main`.`id` = 1672836 OR `props-main`.`id` = 1698807 OR `props-main`.`id` = 1658740 OR `props-main`.`id` = 1679463 OR `props-main`.`id` = 1698484 OR `props-main`.`id` = 1687991 OR `props-main`.`id` = 1688232 OR `props-main`.`id` = 1677845 OR `props-main`.`id` = 1641603 OR `props-main`.`id` = 1692519 OR `props-main`.`id` = 1696437 OR `props-main`.`id` = 1701142 OR `props-main`.`id` = 1697844 OR `props-main`.`id` = 1688483 OR `props-main`.`id` = 1651646 OR `props-main`.`id` = 1695009 OR `props-main`.`id` = 1695635 OR `props-main`.`id` = 1661116 OR `props-main`.`id` = 1670934 OR `props-main`.`id` = 1674173 OR `props-main`.`id` = 1687145 OR `props-main`.`id` = 1687292 OR `props-main`.`id` = 1689563 OR `props-main`.`id` = 1690437 OR `props-main`.`id` = 1701219 OR `props-main`.`id` = 1684233 OR `props-main`.`id` = 1695930 OR `props-main`.`id` = 1695931 OR `props-main`.`id` = 1623531 OR `props-main`.`id` = 1668834 OR `props-main`.`id` = 1663980 OR `props-main`.`id` = 1686667 OR `props-main`.`id` = 1679310 OR `props-main`.`id` = 1693384 OR `props-main`.`id` = 1679263 OR `props-main`.`id` = 1651401 OR `props-main`.`id` = 1651403 OR `props-main`.`id` = 1691905 OR `props-main`.`id` = 1680174 OR `props-main`.`id` = 1690991 OR `props-main`.`id` = 1697760 OR `props-main`.`id` = 1679240 OR `props-main`.`id` = 1694046 OR `props-main`.`id` = 1695016 OR `props-main`.`id` = 1694043 OR `props-main`.`id` = 1695018 OR `props-main`.`id` = 1623273 OR `props-main`.`id` = 1691542 OR `props-main`.`id` = 1701143 OR `props-main`.`id` = 1695013 OR `props-main`.`id` = 1691081)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsPI25218918' 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.
