Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
Array
(
[RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(PropertyType eq 'Land' or PropertyType eq 'Residential' or PropertyType eq 'Residential Income') and (Appliances eq 'Back Porch - Uncovered,Back Porch - Screened' OR ArchitecturalStyle eq 'Back Porch - Uncovered,Back Porch - Screened' OR CommunityFeatures eq 'Back Porch - Uncovered,Back Porch - Screened' OR Cooling eq 'Back Porch - Uncovered,Back Porch - Screened' OR CountyOrParish eq 'Back Porch - Uncovered,Back Porch - Screened' OR ElementarySchool eq 'Back Porch - Uncovered,Back Porch - Screened' OR ExteriorFeatures eq 'Back Porch - Uncovered,Back Porch - Screened' OR Flooring eq 'Back Porch - Uncovered,Back Porch - Screened' OR Heating eq 'Back Porch - Uncovered,Back Porch - Screened' OR HighSchool eq 'Back Porch - Uncovered,Back Porch - Screened' OR InteriorFeatures eq 'Back Porch - Uncovered,Back Porch - Screened' OR ListingTerms eq 'Back Porch - Uncovered,Back Porch - Screened' OR MiddleOrJuniorSchool eq 'Back Porch - Uncovered,Back Porch - Screened' OR ParkingFeatures eq 'Back Porch - Uncovered,Back Porch - Screened' OR PoolFeatures eq 'Back Porch - Uncovered,Back Porch - Screened' OR PropertyType eq 'Back Porch - Uncovered,Back Porch - Screened' OR Roof eq 'Back Porch - Uncovered,Back Porch - Screened' OR SchoolDistrict eq 'Back Porch - Uncovered,Back Porch - Screened' OR Sewer eq 'Back Porch - Uncovered,Back Porch - Screened' OR Utilities eq 'Back Porch - Uncovered,Back Porch - Screened' OR WaterfrontFeatures eq 'Back Porch - Uncovered,Back Porch - Screened') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true] => Array
(
[RF Response] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse Object
(
[items] => Array
(
[0] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 136254
[post_author] => 1
[ListingKey] => 641669
[ListingId] => 641669
[PropertyType] => Residential
[PropertySubType] => Single Family
[StandardStatus] => Active
[ModificationTimestamp] => 2026-08-26T21:30:50Z
[RFModificationTimestamp] => 2026-08-26T21:36:46Z
[ListPrice] => 719000
[BathroomsTotalInteger] => 5
[BathroomsHalf] => 1
[BedroomsTotal] => 5
[LotSizeArea] => 1.3
[LivingArea] => 4594
[BuildingAreaTotal] => 5094
[City] => Irmo
[PostalCode] => 29063
[UnparsedAddress] => 13 Ascot Glen Court, Irmo, SC 29063
[Coordinates] => Array
(
[0] => -81.170449
[1] => 34.130054
)
[Latitude] => 34.130054
[Longitude] => -81.170449
[YearBuilt] => 2002
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => Century 21 803 Realty
[ListAgentMlsId] => 12946
[ListOfficeMlsId] => 1073
[OriginatingSystemName] => columbiamls
[PublicRemarks] => ***SERIOUS CASH INVESTORS OR CASH BUYERS****Looking to move into a prestigious neighborhood as an investment opportunity...Welcome home to this stunning 5,000 square foot custom-built masterpiece by Sovereign, nestled on 1.3 private acres in the prestigious Ascott Glenn community. This 5-bedroom, 4.5-bath estate offers the space, craftsmanship, and flow today's buyers are searching for, with a rare primary suite on the main level.Step through the foyer into a beautifully connected formal living and dining room, setting an elegant tone for the home. The heart of the home is the chef's kitchen, featuring custom cabinetry, a gas cooktop, a built-in microwave/oven combination, and a strikingly decorative hood. The kitchen flows effortlessly into the eat-in area, kitchen bar, and spacious living room anchored by a cozy fireplace — the ultimate entertainer's layout. Primary bedroom is located on the main level with a fireplace, his, her closets and large Rich hardwoods and elegant columns add architectural character throughout the main level, while a second fireplace warms the living space beside French double doors opening to a screened-in porch and additional deck, overlooking your expansive, private backyard.Upstairs, four generously sized bedrooms each with a walk-in closet, with a thoughtfully designed Jack-and-Jill bath providing privacy and function for family or guests. Rounding out this exceptional floor plan: a dedicated office, media room, and a bonus game room/gym space, offering flexibility for work, play, and fitness.This home has all the bones — soaring craftsmanship, a coveted location, and a layout built for living — and simply needs a little TLC to restore it to its full potential. Bring your vision and make this Ascott Glenn showplace shine again! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[Appliances] => Dishwasher,Refrigerator,Microwave Built In
[ArchitecturalStyle] => Colonial
[AssociationYN] => 1
[Basement] => No Basement
[BuildingAreaUnits] => Sqft
[CoListAgentEmail] => ty@brazellsignatureteam.com
[ConstructionMaterials] => Brick-All Sides-AbvFound
[Cooling] => Central
[CountyOrParish] => Richland
[CreationDate] => 2026-08-26T21:25:23.006771+00:00
[Directions] => Please use GPS for the best directions.
[ExteriorFeatures] => Back Porch - Uncovered,Back Porch - Screened
[FireplaceFeatures] => Gas Log-Natural
[Heating] => Central
[InteriorFeatures] => BookCase,Ceiling Fan,Garage Opener,Smoke Detector
[InternetEntireListingDisplayYN] => 1
[LaundryFeatures] => Electric,Heated Space
[ListAgentEmail] => heather@brazellsignatureteam.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => ACTIVE
[OriginalEntryTimestamp] => 2026-08-25
[PhotosChangeTimestamp] => 2026-08-26T21:24:38Z
[PhotosCount] => 1
[RoadFrontageType] => Paved
[RoomKitchenFeatures] => Counter Tops-Granite,Floors-Tile,Backsplash-Tiled,Cabinets-Glazed
[Sewer] => Public
[StateOrProvince] => SC
[StreetName] => Ascot Glen
[StreetNumber] => 13
[StreetSuffix] => Court
[SubdivisionName] => ASCOT GLEN
[WaterSource] => Public
[TMS] => 04116-06-05
[Baths] => 5
[Range] => Counter Cooktop,Gas
[Garage] => Garage Attached, side-entry
[Address] => 13 Ascot Glen Court
[AssnFee] => 1200
[LVTDate] => 2026-08-26
[LotSize] => 0
[PowerOn] => Yes
[Location] => Cul-de-Sac
[BathsFull] => 4
[#ofStories] => 2
[2ndBedroom] => Closet-Walk in,Bath-Jack & Jill
[3rdBedroom] => Closet-Walk in,Bath-Jack & Jill
[4thBedroom] => Closet-Walk in,Bath-Jack & Jill
[BathsCombo] => 4 / 1
[HighSchool] => Dutch Fork
[IDXInclude] => Yes
[LivingRoom] => Entertainment Center,Fireplace,French Doors,Floors-Hardwood
[New/Resale] => Resale
[OtherRooms] => Bonus-Finished,Media Room,Office
[class_name] => RE_1
[GarageLevel] => Main
[LA1UserCode] => BRAZEH
[Co-ListAgent] => 14292
[GarageSpaces] => 3
[MiddleSchool] => Dutch Fork
[PricePerSQFT] => 156.51
[ShortSaleY/N] => No
[StatusDetail] => 0
[AgentHitCount] => 3
[Co-ListOffice] => 1073
[FullBaths-2nd] => 3
[Level-Kitchen] => Main
[MasterBedroom] => Double Vanity,Fireplace,Tub-Garden,Closet-His & Her,Bath-Private,Separate Shower,Closet-Walk in,Ceilings-High (over 9 Ft),Closet-Private,Separate Water Closet
[Miscellaneous] => Built-ins,Sidewalk Community
[AvailFinancing] => Cash
[FullBaths-Main] => 1
[GeoSubdivision] => SC
[HalfBaths-Main] => 1
[Level-Bedroom2] => Second
[Level-Bedroom3] => Second
[Level-Bedroom4] => Second
[SchoolDistrict] => Lexington/Richland Five
[LO1MainOfficeID] => 1073
[Level-OtherRoom] => Second
[OtherHeatedSqFt] => 500
[AssocFeeIncludes] => Clubhouse,Common Area Maintenance,Playground,Pool,Road Maintenance,Street Light Maintenance,Tennis Courts,Green Areas
[ElementarySchool] => River Springs
[FormalDiningRoom] => Molding,Ceilings-High (over 9 Ft)
[FormalLivingRoom] => Molding,Ceilings-High (over 9 Ft)
[LA1AgentLastName] => Brazell
[Level-LivingRoom] => Main
[Level-OtherRoom2] => Second
[ListPriceTotSqFt] => 156.51
[RollbackTax(Y/N)] => No
[Assn/RegimeFeePer] => Yearly
[LA1AgentFirstName] => Heather
[Level-WasherDryer] => Main
[ForeclosedProperty] => Yes
[GeoUpdateTimestamp] => 2026-08-26T21:24:38.2
[AddressSearchNumber] => 13
[LO1OfficeIdentifier] => 1073
[Level-MasterBedroom] => Main
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[Interior#ofFireplaces] => 2
[LO1OfficeAbbreviation] => WIHS01
[FirstPhotoAddTimestamp] => 2026-08-26T21:24:38.4
[Level-FormalDiningRoom] => Main
[Level-FormalLivingRoom] => Main
[MlsAreaMajor] => Irmo/St Andrews/Ballentine
[PrivatePoolYN] => No
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6416690
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641669/9f15c61c804c545fb10ddc3509fe0c8e.webp
[ClassName] => Single Family
[MediaSize] => 763925
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641669/thumbnail-9f15c61c804c545fb10ddc3509fe0c8e.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641669
)
)
[DaysOnMarket] => 1
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('641669')
[ID] => 136254
)
)
[success] => 1
[page_size] => 1
[page_count] => 1
[count] => 1
[after_key] =>
)
[RF Response Time] => 0.14 seconds
)
)