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 = 361 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 = 361 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 = 361 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;

5790 Se 122nd Avenue
Morriston, FL 32668

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $449,600
Beds: 4
Baths: 3
Status: Active
SqFt: 2692
Agency: Triple Crown Realty of Ocala, Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: 2022
Notes: 2022 CUSTOM BUILT TRIPLE WIDE ON 5 PRIVATE ACRES IN MORGAN FARMS! THIS 2693 SQFT ARLINGTON MODEL BOASTS OF EXQUISITE CRAFTSMANSHIP! FROM THE MOMENT YOU WALK IN THE FRONT DOOR AND AT EVERY TURN YOU WILL SEE THE ATTENTION TO DETAIL GIVEN IN DESIGNING THIS CUSTOM HOME.<br /> <br /> FEATURING 4 GENEROUSLY SIZED BEDROOMS AND 3 SPACIOUS BATHROOMS, AN OPEN FLOOR PLAN, CROWN MOLDING AND HIGH END VINYL FLOORING THROUGHOUT ALONG WITH CUSTOM CEILINGS, THIS HOME IS LUXURY THROUGH AND THROUGH! ALSO, FEATURING A GOURMET CHEF'S KITCHEN WITH STAINLESS STEEL APPLIANCES, A FARMHOUSE SINK, A MASSIVE KITCHEN ISLAND, WALK IN PANTRY, PREMIUM LIGHTING AND GENEROUS CABINET AND PANTRY SPACE. THE LIVING ROOM BOASTS A STONE, WOOD BURNING FIREPLACE AND OFF OF THE LIVING ROOM IS YOUR VERY OWN HOME OFFICE WITH A BUILT IN DESK AND CABINETS. CUSTOM BARN DOORS TAKE YOU INTO A SPACIOUS FAMILY ROOM PERFECT FOR ENTERTAINING. THIS HOME ALSO FEATURES A MASSIVE OWNER'S SUITE WITH A HUGE WALK IN CLOSET. THE MASTER BATH FEELS LIKE YOUR VERY OWN SPA WITH A LARGE SOAKING TUB, WALK IN GLASS AND TILE SHOWER, DOUBLE VANITIES, LONG COUNTERTOPS AND A MAKEUP AREA. <br /> <br /> WALK OUTSIDE AND LET YOUR IMAGINATION RUN WILD! CREATE ANYTHING YOU DESIRE. WITH NO HOA THE POSSIBILITIES ARE ENDLESS! THERE IS ALSO A 10 X 20 STORAGE SHED ON THE PROPERTY AS WELL.<br /> <br /> DO NOT MISS THIS OPPORTUNITY TO OWN YOUR OWN PEACEFUL PARADISE!
MlsNumber: OM674118


Listing Provided By: Triple Crown Realty of Ocala, Inc, original listing
Name: Triple Crown Realty of Ocala, Inc
Phone: (352) 671-2900
Office Name: TRIPLE CROWN RLTY/OCALA
Office Phone: (352) 671-2900
Agent Name: Kristi Foret
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App