The results of your search can be seen on the map and below in a list. Your search returned 4 results with up to 20 shown on map. Map results change with the results below. Click next to view the next set of results.
Your Search Results
Showing page 1 of 1 pages
SELECT MLS_LISTING_ID AS mls_listing_id, latitude, longitude, concat(STREET_NUMBER, " ", STREET_NAME, " ", STREET_TYPE, " ", STREET_DIRECTION, ", ", CITY, " ", MLS_STATE_ID) AS address, street_name, city, zip_code, mls_state_id, sale_price, bedrooms, baths_half, baths_full, building_square_footage, LEFT(remarks, 185) AS remarks, subdivision, property_type_code, photo_url, photo_quantity FROM mlsData WHERE mls_id !="" AND city = "TAMPA" AND subdivision LIKE "%WESTCHASE%" AND property_type_code = "M" ORDER BY sale_price, building_square_footage DESC LIMIT 0, 20
$119,000.00
Condo\Town Home
2 Bed, 2 Bath
1,423 Sq. Ft.
$159,900.00
Condo\Town Home
2 Bed, 2.5 Bath
1,276 Sq. Ft.
$199,900.00
Condo\Town Home
4 Bed, 3 Bath
2,281 Sq. Ft.
$295,000.00
Condo\Town Home
3 Bed, 2.5 Bath
2,067 Sq. Ft.
GORGEOUSE UPSCALE TOWNHOME IN THE GATED COMMUNITY OF SAVILLE ROWE IN WESTCHASE CONVENIENTLY LOCATED NEXT TO THE WESTCHASE GOLF CLUB! PREPARE TO BE IMPRESSED BY THE PANORAMIC VIEWS AND ...
View Details »
Showing page 1 of 1 pages
