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;

10015 Stycket Ave
Hastings, FL 32145

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $369,900
Beds: 4
Baths: 2
Status: Active
SqFt: 1600
Agency: Century 21, St. Augustine Properties, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2023
Notes: New Construction By Old City Homes Llc - Beautiful And Room To Breathe. No Hoa And No Cdd,4 Bdrm 2 Bath,2 Car Garage On Huge Lot. On Over 1 Acre Of Privacy Plus Plenty Of Room For A Pool,Separate Garage And All Your Toys. 4 Bedrooms With A Combination Kitchen/Dining/Great Room Open Floor Plan Configuration. Quality Built Slab Foundation,30 Year Architectural Shingles,Vinyl Insulated Windows,Wood Cabinets And Granite Counters,Bring Your Rv,Boat And 4 Wheelers! Plenty Of Room For It All! Home Has 8' & 9' Ceilings,Solid Wood Cabinets,Granite Countertops,Washer/Dryer Hookups,Stainless Steel Appliances,Laminate/Tile Flooring Throughout,40 Gal. Water Heater,Architectural Asphalt Shingles,Ceramic Tiled Showers,6 Panel Doors,Vinyl Windows,Garage Door Opener W/Remotes; Ready For A Move? Reserve Your New Home Today And Get Yours On The Market. Call For Details. Pictures Attached Are Of An Exact Model Home.,Open Rural Zoning - Great For Horses,Bring Your Big Toys,Enjoy Your Privacy,Well And Septic Systems Are Brand New. Split Plan Provides Excellent Privacy For The Entire Family. Enjoy Privacy While Enjoying Our Florida Fresh Air All The Time! If You Feel Like Venturing Out. Only A 30-minute Drive To Downtown St Augustine,20-minute Drive To Shopping Malls Or Better Yet 30 Minute Drive To The Beach!! This Is It!
MlsNumber: 233851


Listing Provided By: Century 21, St. Augustine Properties, Inc., original listing
Name: Century 21, St. Augustine Properties, Inc.
Phone: (904) 797-6000
Office Name: Century 21 St Augustine Properties
Office Phone: (904) 797-6000
Agent Name: Tanya Liebal
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