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

1822 Fairview Dr
Port Allen, LA 70767
Sondra Richard with Real Broker LLC, original listing - (855) 450-0442

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $483,555
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2653 Square Feet
Agency: Real Broker LLC
Agency Phone: (855) 450-0442

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1996
Notes: Looking for the perfect home that offers more extras than you can imagine. Your search is over! This stunning 3 bedroom, 3 bath home includes a plethora of features designed for comfort and convenience. This home also has a 367 sq. ft. studio or man cave, perfect for game day or a workout, complete with a kitchen, split AC, and a full bath. Note that this space is not included in the living square footage. A lovely sunroom with French doors opening from the living room, and a second set of doors leading to an amazing courtyard. A 3-car garage, 2 boat ports, a tool room/workshop, and additional storage area that takes all the guesswork out of parking and storage for boats, RVs, lawn equipment, or 4-wheelers. Work from home in the separate office area or use it as a playroom or game room for the kids. The kitchen features lots of custom-built cabinets, an island, granite countertops, and a walk-in pantry large enough for a deep freezer and all the storage space you could ever need. An arched doorway leads from the kitchen dining area to the living room, which boasts a bricked wall and mantel area, a real wood-burning stove, and beautiful views of the sunroom, patio, and courtyard with a flowing water fountain. All bedrooms in this home are generously sized. The master bedroom includes an en-suite bath with a double vanity, granite countertops, and a separate shower. This custom built home also has ceramic tile and wood laminate flooring throughout the home. The roof was replaced in 2021 with architectural shingles. The floor plan of this home allows for comfortable access to both indoor and outdoor spaces, perfect for entertaining family and friends. Situated in the Brusly School District, near the new bridge for easy access to Baton Rouge, shopping, restaurants, and schools. Also we are the second owners of this custom built home. Don't miss out on this extraordinary home! Call and schedule your private showing today! ONLY THE FRIG IN KITCHEN STAYS!
MlsNumber: --
ListingId: 2024013237


Listing Provided By: Real Broker LLC, original listing
Phone: (225) 955-5484
Office Phone: (855) 450-0442
Agent Name: Sondra Richard
Disclaimer: Copyright © 2024 Greater Baton Rouge Association 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