SELECT PropertyID, Title, Price, Address, City, Lot_Size, Square_Feet, Bedrooms, Listing_x, Listing_y, Map_Url
FROM Property
WHERE PropertyType = 'Featured'
AND ( Site_Listed = 'both' OR Site_Listed = 'stim' )
ORDER BY PropertyID ASC
Directions
Velp Avenue to Glendale. Left on Glendale. Left on Chatsworth. Left on Herne Bay. Left on Stockbury
Offering over 1700 +/- sq. ft. p/builder with 3 bedrooms, 2 full baths, 6 panel doors and 3 stall garage. Kitchen/dinette with custom maple cabinetry, snack counter, walk-in pantry, and patio doors off the dinette. Huge living room with cathedral ceilings and a corner gas log fireplace with a tile & wood surround. Master suite offers a tray ceiling, full bath, and a large walk-in closet. 1st floor laundry.
Information herein is not warranted and is subject to change without notice. We assume no liability for errors.
Offered at $189,900
