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

3525 Birkdale Court
Fayetteville, NC 28303

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $449,900
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2948 Square Feet
Agency: EXP REALTY LLC
Agency Phone: (888) 584-9431

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Oven, Washer, Microwave, Range, Refrigerator, Garbage Disposer, Dryer
Architectural Style: Other
Construction Materials: Brick
Flooring: Carpet, Tile, Hardwood
Heating: Fireplace
Interior Features: Ceiling Fans, Entrance Foyer, Pantry, Eatin Kitchen, Security System, Builtin Features, Storage, In Law Floorplan, Attic, Recessed Lighting, Primary Downstairs, Crown Molding, Double Vanity, Granite Counters, Chandelier, MULTIPLE CLOSETS, Separate Formal Dining Room, Bathin Primary Bedroom, Garden Tub Roman Tub, Living Dining Room, Hisand Hers Closets, Multiple Master Suites
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4
Security Features: Security System

Window Features

Exterior Features: Fence, Porch, Patio, Corner Lot, Cleared, Rain Gutters
Fencing: Fenced
Parking Features: Garage
Patio and Porch Features: Patio, Porch
Vegetation: Cleared

Neighborhood/Schools

Elementary School/District: Vanstory Hills Elementary (3-5)
Middle/Junior High School/District:
High School/District: Terry Sanford Senior High
Subvidision Name: Woodlands

Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: Have you been searching for a home with 2 primary suites? This 4 bedroom, 3.5 bathroom home is sure to impress with the amount of space and upgrades. Downstairs features a formal dining room, formal living room, large kitchen, eat in kitchen, laundry room, den, primary suite and half bathroom. The kitchen has SS appliances, tile backsplash, granite countertops, recessed lighting, hardwood floors, under cabinet lighting, pantry & EIK. The laundry room is off the kitchen & doubles as a mud room from the garage. The spacious primary suite downstairs offers double vanities, a large walk in closet & sep tub/shower. The 2nd primary suite upstairs has 2 closet (one being a walk in), double vanities and an upgraded massive tile shower. The 2 bedrooms upstairs are oversized w/ double closets & built in bookshelves. The 3rd bathroom upstairs offers dual vanities & ample storage space. Large corner lot has plenty of privacy w/ the different types of shrubs and landscaping
MlsNumber: --
ListingId: 720664


Listing Provided By: EXP REALTY LLC, original listing
Phone: (888) 584-9431
Office Phone: (888) 584-9431
Agent Name: AISLING BONNER
Disclaimer: Copyright © 2024 Longleaf Pine 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