Tequesta

All Listings $200,000 - $300,000 Over $1,000,000

76 Search Results Found. Showing Results 1 - 15.

1 2 3 4 5 6 »

MLS# R2980687

MLS ID: R2980687
Price: $3,000,000
City: Tequesta
Bedrooms: 4 Bathrooms: 6
Property Type: Residential

MLS# R3095809

MLS ID: R3095809
Price: $2,900,000
City: Tequesta
Bedrooms: 4 Bathrooms: 4
Property Type: Residential

MLS# R3073143

MLS ID: R3073143
Price: $2,395,000
City: Tequesta
Bedrooms: 4 Bathrooms: 5
Property Type: Residential

MLS# R3129122

MLS ID: R3129122
Price: $1,995,000
City: Tequesta
Bedrooms: 4 Bathrooms: 4
Property Type: Residential

MLS# R3078354

MLS ID: R3078354
Price: $1,875,000
City: Tequesta
Bedrooms: 4 Bathrooms: 3
Property Type: Residential

MLS# R3095977

MLS ID: R3095977
Price: $1,700,000
City: Tequesta
Bedrooms: 2 Bathrooms: 2
Property Type: Residential

MLS# R3117141

MLS ID: R3117141
Price: $1,319,000
City: Tequesta
Bedrooms: 4 Bathrooms: 2
Property Type: Residential

MLS# R2783711

MLS ID: R2783711
Price: $1,225,000
City: Tequesta
Bedrooms: 4 Bathrooms: 2
Property Type: Residential

MLS# R3115508

MLS ID: R3115508
Price: $950,000
City: Tequesta
Bedrooms: 3 Bathrooms: 2
Property Type: Residential

MLS# R3063342

MLS ID: R3063342
Price: $899,000
City: Tequesta
Bedrooms: 3 Bathrooms: 2
Property Type: Residential

MLS# R3091425

MLS ID: R3091425
Price: $629,000
City: Tequesta
Bedrooms: 3 Bathrooms: 2
Property Type: Residential

MLS# R2918475

MLS ID: R2918475
Price: $625,000
City: Tequesta
Bedrooms: 3 Bathrooms: 2
Property Type: Residential

MLS# R3114616

MLS ID: R3114616
Price: $595,000
City: Tequesta
Bedrooms: 3 Bathrooms: 2
Property Type: Residential

MLS# R3128844

MLS ID: R3128844
Price: $574,900
City: Tequesta
Bedrooms: 3 Bathrooms: 3
Property Type: Residential

MLS# R3125250

MLS ID: R3125250
Price: $444,900
City: Tequesta
Bedrooms: 4 Bathrooms: 2
Property Type: Residential
1 2 3 4 5 6 »
SELECT `ML_Number` AS 'mls_number', `List_Price` AS 'price', `Status` AS 'status', `Bedrooms` AS 'bedrooms', `Full_Baths` AS 'bathrooms', `Address` AS 'address', `Area_Number` AS 'area', `City` AS 'city', `Sub_Type` AS 'subtype', `Zip_Code` AS 'zip_code', `Liv_Area_SqFt` AS 'sqft', `Year_Built` AS 'year', `Public_Remarks` AS 'remarks', `ML_Number` AS 'image', `List_Office_Name` AS 'office', `List_Office_ID` AS 'officeid', `List_Agent_Name` AS 'agent', `List_Agent_Email` AS 'agent_email', `List_Agent_ID` AS 'agent_id', `List_Agent_Phone` AS 'agent_phone', `Subdivision_Name` AS 'subdivision', `Virtual_Tour_Link` AS 'virtual_tour', `Lot_Size` AS 'acres', `Development_Name` AS 'development', `County_Name` AS 'county', `Waterfront_YN` AS 'waterfront_yn', `View` AS 'view', `Pool_Y/N` AS 'pool_yn', `Cooling` AS 'cooling', `Equipment` AS 'equipment', `Front_Exposure` AS 'front_exposure', `Furnished` AS 'furnished', `Governing_Body` AS 'governing_body', `Restrictions` AS 'restrictions', `Security` AS 'security', `Utilities` AS 'utilities', `Total_Bldg_SF_Incl` AS 'total_sqft', `Total_Floors` AS 'total_floors', `Total_Units_in_Bldg` AS 'units_in_bldg', `Total_Units_in_Complex` AS 'units_complex', `Unit_Description` AS 'unit_desc', `Tax_ID` AS 'parcel_id', `Half_Baths` AS 'half_baths', `Parking` AS 'parking', `Parking` AS 'parking_space_num', `Pets_Allowed` AS 'pets_allowed', `Roof` AS 'roof', `Rooms` AS 'rooms', `Waterfront_Desc` AS 'waterfront_desc', `Window_Treatment` AS 'window_treatment', `Year_Built_Desc` AS 'year_built_desc', `Zip_Plus4` AS 'zip_plus4', `Tax_Amount` AS 'tax_amount', `Subdivision_Info` AS 'subdivision_info', `Master_Bdrm_Bath` AS 'master_bdrm_bath', `Market_Time` AS 'market_time', `HOA` AS 'hoa', `HOA_Amount` AS 'hoa_amount', `HOA_Fee_Per` AS 'hoa_fee_per' FROM idx_res WHERE REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(`City`, '.', ''), '/', ''), ')', ''), '(', ''), ' ', ' ') = UPPER('Tequesta') AND (`Subdivision_Name` LIKE '%Tequesta%') AND `Bedrooms` <= 100 AND `Full_Baths` <= 100 AND `Year_Built` >= 1900 ORDER BY List_Price DESC LIMIT 0,15