Mallory Creek

5.  Mallory Creek - Mallory Creek is one of the newer developments in Abacoa.  A community of town homes and single family homes built  Key West style, Mallory Creek is located near Roger Dean Stadium and Abacoa Town Center and offers great shopping and fine dining close by.

All Listings $200,000 - $300,000 $300,000 - $400,000
$500,000 - $600,000 $600,000 - $700,000

6 Search Results Found. Showing Results 1 - 6.

MLS# R3105735

MLS ID: R3105735
Price: $636,700
City: Jupiter
Bedrooms: 5 Bathrooms: 4
Property Type: Residential

MLS# R3134577

MLS ID: R3134577
Price: $579,000
City: Jupiter
Bedrooms: 5 Bathrooms: 4
Property Type: Residential

MLS# R3113444

MLS ID: R3113444
Price: $399,900
City: Jupiter
Bedrooms: 3 Bathrooms: 3
Property Type: Residential

MLS# R3067705

MLS ID: R3067705
Price: $399,900
City: Jupiter
Bedrooms: 3 Bathrooms: 2
Property Type: Residential

MLS# R3127912

MLS ID: R3127912
Price: $315,000
City: Jupiter
Bedrooms: 3 Bathrooms: 2
Property Type: Residential

MLS# R3127636

MLS ID: R3127636
Price: $220,000
City: Jupiter
Bedrooms: 3 Bathrooms: 2
Property Type: Residential
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('Jupiter') AND (`Subdivision_Name` LIKE '%Mallory Creek @ Abacoa%' OR `Subdivision_Name` LIKE '%Mallory Creek at Abacoa 01%') AND `Bedrooms` <= 100 AND `Full_Baths` <= 100 AND `Year_Built` >= 1900 ORDER BY List_Price DESC