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 = 377 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 = 377 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 = 377 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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;

242 Se 2nd Avenue
Melrose, FL 32666

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $479,000
Beds: 4
Baths: 3
Status: Active
SqFt: 1865
Agency: First Choice Realty of North Florida LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: Under Construction. Seller offering Rate buydown and paid appraisal with preferred lender! PICTURES ARE OF A MODEL HOME with similar floorplan! Welcome to your future dream home located in desirable Seminole Woods neighborhood in Melrose with access to 6800 acre Lake Santa Fe - Private Deeded Access. Nestled in the quiet community of Melrose in sought-after Clay County, this property has deeded private access to Lake Santa Fe. This stunning property is currently under construction and presents an incredible opportunity for those seeking lake life. The seller is even offering a rate buydown for your convenience. This spacious open floorplan home boasts 4 bedrooms, 2 baths, and an impressive 1,865 square feet of living space. The heart of the home, a generously sized kitchen, features real wood cabinets, an island, and stainless steel appliances, including a refrigerator. Say goodbye to HOA fees with this no-HOA property! The completion date is estimated to be around April/May 2024, allowing you to customize your living space to your exact tastes. You have the exciting opportunity to pick your colors! Inside, you'll find crown molding, granite countertops throughout the home, a separate dining room, and a large owner's suite complete with a walk-in closet and dual vanities in the master bathroom. The master bathroom also includes a luxurious walk-in shower. Convenience is key with a large laundry/utility room, ensuring your daily chores are a breeze. Step outside to relax on the veranda overlooking your future backyard oasis. This home is designed with energy efficiency in mind, featuring low E windows and luxury vinyl plank flooring throughout the entire home, with tiled flooring in the bathrooms. Say goodbye to carpet! Additional features include a 2-car garage, a landscaping package, a 14 SEER AC system, and all-concrete exterior with hardiboard siding. Worried about the quality of construction? Rest easy with the builder's 1-year cosmetic warranty and a 10-year structural warranty for peace of mind. Please note that the pictures provided are of a model home, so you can envision the exceptional finishes and design that await you. Melrose is well known for its “Rich Cultural Community” but has it all including restaurants, doctors, senior center, shopping, art galleries, music events with vendors and locally grown produce. Melrose is conveniently located between Gainesville, Palatka and Ocala. Don't miss the opportunity to make this soon-to-be-completed house your forever home. Contact us today for more information and to schedule a visit!
MlsNumber: GC516723


Listing Provided By: First Choice Realty of North Florida LLC, original listing
Name: First Choice Realty of North Florida LLC
Phone: (352) 514-9508
Office Name: FIRST CHOICE REALTY OF NORTH FLORIDA LLC
Office Phone: (352) 514-9508
Agent Name: Dawn Johnson
Disclaimer: Copyright © 2024 Stellar MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 377 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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;
Real Estate Expert Photo for Chris Fields
Chris Fields
ASCIIWatson Realty Corp
Call Today!: (386) 916-5002

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App