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/SC26134131/490-Warwick-St/Cambria/https://www.londonproperties.com/images/props/crmls/full/SC26134131.jpgLondon Properties Cambria Real Estate | 490 Warwick St
Listing Agent: Kate Hendrickson, BHGRE HAVEN PROPERTIES
Charming 3 bedroom, 2 bath home on a corner lot in the desirable Happy Hill neighborhood just moments from Cambria's shops, restaurants and the scenic shores of Moonstone Beach. Sunlit upper-level great room features large windows and wood floors. Adjacent spacious living room offers a gas fireplace and sliding doors to a view deck. The bright, open kitchen boasts generous cabinetry, quartz counters and bar seating, with a dining area that opens via sliding door to a large deck with tree studded views to the ocean. A versatile bonus room with parquet floors, built-in desk and floor-to-ceiling wood shelving is ideal as a den, home office/library or workout space. Additional comforts include solar, a detached 2-car garage, indoor laundry and mudroom, inviting landscaping with stone walkways and a cozy backyard. Perfect blend of classic character and coastal convenience.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1975
Year Built Source
Assessor
Special Listing Conditions
Trust
Stories Total
2
Levels
Two
Number Of Units Total
1
Entry Level
1
Entry Location
Front
Price Per Square Foot
$505
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
No
Heating Y/N
Yes
Directions
From Hwy 1 north, right on Windsor, Left of Charing, right on Warwick. Property is on corner of Warwick and Coventry
Room Type
Laundry, Bonus Room, See Remarks, Kitchen, Main Floor Bedroom, Den
Heating
Forced Air
Cooling
None
Laundry Y/N
Yes
Laundry Features
Individual Room
Roof
Composition
Main Level Bedrooms
2
Bathrooms Full
1
Bathrooms Full And Three Quarter
2
Bathrooms Three Quarter
1
Main Level Bathrooms
1
Room Kitchen Features
Kitchen Open to Family Room, Quartz Counters
Eating Area
Area
Appliances Y/N
Yes
Appliances
Disposal, Refrigerator, Gas Range, Dishwasher
Flooring
Vinyl, Carpet, Wood
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Gas, Living Room
Pool Features
None
Pool Private Y/N
No
Water Source
Public
Sewer
Public Sewer
Parking Total
2.00
Attached Garage Y/N
No
Garage Spaces
2.00
Lot Features
Corner Lot, Landscaped
Lot Size Area
2930.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Ocean, Trees/Woods, Neighborhood, Peek-A-Boo
Common Interest
None
Parcel Number
022033013
Additional Parcels Y/N
No
Subdivision Name
Happy Hill(410)
Subdivision Name Other
Happy Hill(410)
Community Features
BLM/National Forest
Senior Community Y/N
No
Association Y/N
No
High School District
Coast Unified
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
22
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1092500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1207500 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) >= 2027 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2527 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` = 1716860 OR `props-main`.`id` = 1715036 OR `props-main`.`id` = 1696571 OR `props-main`.`id` = 1728863 OR `props-main`.`id` = 1623384 OR `props-main`.`id` = 1678374 OR `props-main`.`id` = 1736470 OR `props-main`.`id` = 1720756 OR `props-main`.`id` = 1719212 OR `props-main`.`id` = 1685443 OR `props-main`.`id` = 1689135 OR `props-main`.`id` = 1678678 OR `props-main`.`id` = 1707099 OR `props-main`.`id` = 1695227 OR `props-main`.`id` = 1623330 OR `props-main`.`id` = 1732244 OR `props-main`.`id` = 1737962 OR `props-main`.`id` = 1683857 OR `props-main`.`id` = 1676382 OR `props-main`.`id` = 1723851 OR `props-main`.`id` = 1654369 OR `props-main`.`id` = 1728016 OR `props-main`.`id` = 1623382 OR `props-main`.`id` = 1707241 OR `props-main`.`id` = 1705320 OR `props-main`.`id` = 1701337 OR `props-main`.`id` = 1731139 OR `props-main`.`id` = 1712964 OR `props-main`.`id` = 1740248 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` = 1738345 OR `props-main`.`id` = 1738352 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` = 1741806 OR `props-main`.`id` = 1736543 OR `props-main`.`id` = 1738744 OR `props-main`.`id` = 1716270 OR `props-main`.`id` = 1739251 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` = 1623374 OR `props-main`.`id` = 1712962 OR `props-main`.`id` = 1741632 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` = 1696938 OR `props-main`.`id` = 1723367 OR `props-main`.`id` = 1739545 OR `props-main`.`id` = 1739671 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` = 1662548 OR `props-main`.`id` = 1671625 OR `props-main`.`id` = 1737076 OR `props-main`.`id` = 1623328 OR `props-main`.`id` = 1719218 OR `props-main`.`id` = 1741820 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`) != 'crmlsSC26134131' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-24' 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.
