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;

198 Paranza Trce
St Augustine, FL 32095

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $635,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2341
Agency: Atlantic Partners Realty St Augustine LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2020
Notes: Nestled In Madeira You Will Find This Stunning Mastercraft Home. This 3bd/2 ½ Ba Home Offers The Laid-back Florida Lifestyle Combining Modern Upgrades And Finishes,Creating A Blend Of Comfort And Elegance. Built In 2020,This Spacious 2,341 Sf Home Boasts An Open Floor Plan That Seamlessly Integrates With The Generous Backyard,Allowing For Indoor And Outdoor Living.,A Paver Drive Leads You To The Covered Porch That Invites You To Sit And Chat With Neighbors As They Walk By. As You Step Inside,You Will Find The Two Guest Bedrooms With A Jack And Jill Bathroom Off The Entry Foyer. Gorgeous Tile Floors Lead To The Back Of The Home,You Will Find A Laundry Room And Glass French Doors To A Separate Office Or Extra Den. The Heart Of This Home Is The Living Space Where The Kitchen,Dining,And Living Room Flow Together Perfectly For Hosting Friends And Family. The Gourmet Kitchen Is A Chef’s Delight With A Gas Range,Stainless Steel Appliances,A Step-in Pantry And Quartz Countertops. Guests Can Pull Up A Stool To The Island For Extra Seating Or A More Casual Meal. A Glass Door From The Living Room Takes You Out The Backyard With A Covered Porch To Sit And Watch The Kids Play A Game Of Catch Or Just Sit And Enjoy Your Morning Coffee. Back Inside Off The Living Area Is The Luxurious Master Bedroom With En Suite Bathroom That Features An Oversized Tiled Shower,Dual Vanities And A Walk-in Closet. The Abundant Natural Light And Neutral Palette Creates A Bright And Cheerful Ambiance. Living In Madeira Includes Access To A Community Pool,A Fitness Center,A Clubhouse,And The Security Of Being In A Gated Community. Located Just A Short Drive From The Beach,Downtown St Augustine,Shopping And Dining Makes This The Ideal Home. Welcome!
MlsNumber: 238715


Listing Provided By: Atlantic Partners Realty St Augustine LLC, original listing
Name: Atlantic Partners Realty St Augustine LLC
Phone: (904) 797-7442
Office Name: Keller Williams St Augustine
Office Phone: (904) 797-7442
Agent Name: Noah Bailey
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