Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

243 Mustard Hill Ct
St Augustine, FL 32084

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $294,500
Beds: 2
Baths: 3
Status: Active
SqFt: 1259
Agency: Watson Realty Corp

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2022
Notes: This Beautiful Two-story Townhome Features,Spectacular 9 Ft Ceilings With Fans. Open Kitchen Concept Features 30-inch Upper Woodmont Cabinets And Solid Surface Countertops. Home Has Stainless Steel Appliances That Include Dishwasher,Vented Microwave,And Side By Side Refrigerator And Oversized Pantry. Features ½ Bath Downstairs,Coat Closet,Plus Luxury Vinyl Flooring On The First Floor With Carpet On The Second Floor. The Washer/Dryer Hookup Is Conveniently Located Upstairs. Guest Bathroom Is Tub/Shower Combined With Deep Sink,Tile Flooring,A Ceiling Fan,And Solid Surface Vanity. The Master Bathroom Has Tile Flooring A Tub/Shower Combined With Deep Sink,Ceiling Fan,Deep Master Closet And Solid Surface Vanity. Townhome Has A Beautiful Patio With Pavers,One Car Garage And Features Great Privacy.,Treaty Park Is A 47-acre Complex That Is Home To Paws Dog Park And Robert Laryn Skate Park. Treaty Park Offers Active And Passive Recreation Amenities To Citizens Of All Ages. For The Softball Enthusiast,Four Lighted 300' Softball Fields And Adult Leagues Are Available For All Levels Of Play. Two Multi-purpose Fields Are Available For Soccer; Kite Flying,Ultimate Frisbee,Pick-up Flag Football Games Or Any Other Activity That Requires An Open Field. For The "court" Enthusiast,There Are Six Lighted Tennis Courts,Eight Lighted Paddle Tennis Courts,Eight Pickleball Courts,Four Racquetball Courts,Two Bocce Ball Courts And Two Lighted Basketball Courts. A Bicycle Path,Short Of 7/8 Of A Mile,And Jogging/Walking Trail Surrounds The Park. A Handicap-accessible Playground,Horseshoe Courts,Picnic Pavilion,Charcoal Grills,Picnic Tables And Benches Encompass A 3-acre Lake With Nature Trails. The Lake Also Features A Boardwalk From Which You Can Catch-and-release Fish Only (no Cast Nets Permitted).bring Your Furry Friend To Paws Dog Park And Give Them A Chance To Experience Dog Life! They Can Run,Play,Jump,And Enjoy Life Leash Free While Socializing With The Other Dogs At The Park.
MlsNumber: 237524


Listing Provided By: Watson Realty Corp, original listing
Name: Watson Realty Corp
Phone: (904) 494-2575
Office Name: Watson Realty Corp (A1A)
Office Phone: (904) 494-2575
Agent Name: Sheila Clark, PA
Disclaimer: Copyright © 2024 St. Augustine & St. John's County Board of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App