Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2935 +post_id: "31347" +post_author: 1 +"ListingKey": "417060884806766713" +"ListingId": "223027453" +"PropertyType": "Residential" +"PropertySubType": "Condo" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-01-24T09:20:45Z" +"RFModificationTimestamp": "2024-01-24T09:20:45.813396+00:00" +"ListPrice": 614900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1000.0 +"BuildingAreaTotal": 0 +"City": "Sacramento" +"PostalCode": "95864" +"UnparsedAddress": "DEMO/TEST 3180 Adams Rd, Sacramento, CA 95864-5014" +"Coordinates": array:2 [ 0 => -121.493895 1 => 38.5810606 ] +"Latitude": 38.5810606 +"Longitude": -121.493895 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Brenda K Hurst" +"ListOfficeName": "Lyon RE Folsom" +"ListAgentMlsId": "SHURSTBR" +"ListOfficeMlsId": "01LYON11" +"OriginatingSystemName": "Demo" +"PublicRemarks": "**This listings is for DEMO/TEST purpose only** Welcome to luxury Brightwater Towers Condo, where style and value meet by the beach! This exclusive apartment is located on the second floor of the elevator building and features impeccable, recent renovation. The moment you step in into this beautiful, sun-drenched 2 bedrooms, 1 bath with huge balc ** To get a real data, please visit https://dashboard.realtyfeed.com" +"Appliances": "Gas Cook Top,Built-In Refrigerator,Dishwasher,Disposal,Microwave,Double Oven,Warming Drawer" +"ArchitecturalStyle": "Mediterranean" +"BathroomsFull": 5 +"BathroomsPartial": 2 +"BuyerAgencyCompensation": "2.5" +"BuyerAgencyCompensationType": "Percent" +"ConstructionMaterials": "Stucco,Frame" +"ContractStatusChangeDate": "2023-11-30" +"Cooling": "Ceiling Fan(s),Central,MultiUnits,MultiZone" +"CountyOrParish": "Sacramento" +"CreationDate": "2024-01-24T09:20:45.813396+00:00" +"CrossStreet": "MORSE" +"Directions": "TO ADDRESS" +"Disclaimer": "All measurements and calculations of area are approximate. Information provided by Seller/Other sources, not verified by Broker. <BR> All interested persons should independently verify accuracy of information. Provided properties may or may not be listed by the office/agent presenting the information. <BR> Copyright</A> © 2023, MetroList Services, Inc. <BR> Any offer of compensation in the real estate content on this site is made exclusively to Broker Participants of the MetroList® MLS & Broker Participants of any MLS with a current reciprocal agreement with MetroList® that provides for such offers of compensation." +"Electric": "220 Volts in Laundry" +"ElementarySchoolDistrict": "Sacramento Unified" +"ExteriorFeatures": "Balcony" +"Fencing": "Back Yard,Fenced" +"FireplaceFeatures": "Living Room,Master Bedroom,Family Room,Other,Gas Starter" +"FireplacesTotal": "4" +"Flooring": "Carpet,Stone,Wood" +"FoundationDetails": "Raised" +"GarageSpaces": "4.0" +"Heating": "Central,MultiUnits,MultiZone" +"HighSchoolDistrict": "San Juan Unified" +"InteriorFeatures": "Cathedral Ceiling" +"InternetEntireListingDisplayYN": true +"IrrigationSource": "Other" +"LaundryFeatures": "Upper Floor,Inside Room" +"ListAOR": "MetroList Services, Inc." +"ListAgentFirstName": "Brenda" +"ListAgentKeyNumeric": "5006036" +"ListAgentLastName": "Hurst" +"ListOfficeKeyNumeric": "60278" +"LivingAreaSource": "Assessor Auto-Fill" +"LotFeatures": "Auto Sprinkler F&R,Shape Regular" +"LotSizeAcres": 0.7634 +"LotSizeSource": "Assessor Auto-Fill" +"LotSizeSquareFeet": 33254.0 +"MLSAreaMajor": "10864" +"MiddleOrJuniorSchoolDistrict": "San Juan Unified" +"MlsStatus": "Expired" +"OriginatingSystemKey": "MLS Metrolist" +"OtherStructures": "Shed(s)" +"ParcelNumber": "294-0042-005-0000" +"ParkingFeatures": "Attached,RV Garage Attached" +"PhotosChangeTimestamp": "2023-11-30T23:59:59Z" +"PhotosCount": 2 +"PoolFeatures": "Built-In,Pool/Spa Combo" +"PoolPrivateYN": true +"PostalCodePlus4": "5014" +"PriceChangeTimestamp": "1800-01-01T00:00:00Z" +"RoadSurfaceType": "Paved" +"Roof": "Tile" +"RoomDiningRoomFeatures": "Formal Area" +"RoomKitchenFeatures": "Pantry Closet,Granite Counter,Island w/Sink" +"RoomLivingRoomFeatures": "Cathedral/Vaulted" +"RoomMasterBathroomFeatures": "Shower Stall(s),Double Sinks,Soaking Tub" +"RoomMasterBedroomFeatures": "Balcony,Walk-In Closet,Outside Access,Sitting Area" +"RoomType": "Living Room" +"Sewer": "In & Connected" +"SpecialListingConditions": "None" +"StateOrProvince": "CA" +"Stories": "2" +"StreetName": "Adams" +"StreetNumberNumeric": "3180" +"StreetSuffix": "Road" +"SubdivisionName": "SIERRA OAKS VISTA" +"Topography": "Trees Many" +"Utilities": "Cable Available,Electric" +"VideosChangeTimestamp": "2023-11-30T00:08:12Z" +"VideosCount": 1 +"WaterSource": "Well" +"WindowFeatures": "Dual Pane Full" +"YearBuiltSource": "Assessor Auto-Fill" +"ZoningDescription": "RE2" +"HorseYN_C": "0" +"MlsName_C": "NYStateMLS" +"FloorNum_C": "2" +"HamletID_C": "0" +"class_name": "LISTINGS" +"AtticType_C": "0" +"NearBusYN_C": "1" +"StaffBeds_C": "0" +"GarageType_C": "0" +"NoFeeSplit_C": "0" +"SaleOrRent_C": "S" +"StaffBaths_C": "0" +"BrokerWebYN_C": "0" +"KitchenType_C": "Open" +"NearTrainYN_C": "1" +"ShowPriceYN_C": "1" +"UtilitiesYN_C": "0" +"HavePermitYN_C": "0" +"InteriorAmps_C": "0" +"IsSeasonalYN_C": "0" +"LandFrontage_C": "0" +"NearSchoolYN_C": "0" +"Neighborhood_C": "Coney Island" +"AtticAccessYN_C": "0" +"BasesmentSqFt_C": "0" +"HiddenDraftYN_C": "0" +"LastPriceTime_C": "2022-06-29T04:00:00" +"RoomForPoolYN_C": "0" +"CommercialType_C": "0" +"RenovationYear_C": "0" +"CoListAgent2Key_C": "0" +"LastStatusValue_C": "0" +"RoomForGarageYN_C": "0" +"RoomForTennisYN_C": "0" +"BasementBedrooms_C": "0" +"FirstFloorBathYN_C": "0" +"PreWarBuildingYN_C": "0" +"ResidentialStyle_C": "0" +"SouthOfHighwayYN_C": "0" +"BasementBathrooms_C": "0" +"PostWarBuildingYN_C": "0" +"HandicapFeaturesYN_C": "1" +"KitchenCounterType_C": "Granite" +"UndisclosedAddressYN_C": "0" +"PercentOfTaxDeductable_C": "0" +"PhotoModificationTimestamp_C": "2022-09-07T19:31:47" +"LandUse": "Residential" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('417060884806766713')" +"MLSOrigin": "MLS Metrolist" +"MainLevel": "Bedroom(s),Living Room,Dining Room,Family Room,Full Bath(s),Partial Bath(s),Garage,Kitchen" +"ADU2ndUnit": "No" +"LowerLevel": "Bedroom(s),Living Room,Dining Room,Family Room,Full Bath(s),Partial Bath(s),Garage,Kitchen" +"UpperLevel": "Bedroom(s),Master Bedroom,Full Bath(s),Retreat" +"CensusTract": 56.06 +"SearchPrice": 2790000.0 +"RecMlsNumber": "MTR223027453" +"provider_name": "MetroList" +"VirtualTourURL": "https://fusion.realtourvision.com/170861" +"AreaShortDisplay": "10864" +"FeedAvailability": "2023-11-30T00:00:00-08:00" +"PhotosProvidedBy": "3rd Party Photographer" +"RemodeledUpdated": "Unknown" +"PictureCountPublic": 1 +"SubtypeDescription": "Custom" +"PictureCountPrivate": 1 +"SchoolDistrictCounty": "Sacramento" +"SearchContractualDate": "2023-11-30T00:00:00-08:00" +"StreetAddressFiltered": "3180 Adams Rd" +"MultipleListingService": "MLS Metrolist" +"RoomBathsOtherFeatures": "Shower Stall(s),Tub w/Shower Over" +"Media": array:2 [ 0 => array:15 [ "Order" => 1 "MediaKey" => "560492024_0d158c8d-37ee-4adf-b543-15d37eb4e7a0.jpg" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/44/560492024/dbd08e18972d9cd5a4146562f3862ac4.jpeg" "MLSOrigin" => "MLS Metrolist" "MediaSize" => 103876 "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/44/560492024/thumbnail-dbd08e18972d9cd5a4146562f3862ac4.jpeg" "ImageWidth" => 820 "Permission" => "Public" "ImageHeight" => 474 "ThumbnailURL" => "https://mediarem.metrolist.net/metrolist/listingpics/tmbphoto/2023/04/14/0d158c8d-37ee-4adf-b543-15d37eb4e7a0.jpg?tsp=20230414091344" "LongDescription" => "Welcome to this prestigious private gated estate in highly coveted Sierra Oaks Vista. Custom built w/ the utmost attention to detail & craftsmanship,using the finest quality materials,this stunning home exudes architectural integrity.Upon entry, the grand foyer greets you w/ intricately detailed inlaid travertine stone & mahogany built-in cabinetry.The gourmet chef's kitchen boasts high-end appliances,temperature-controlled wine closet,eat-in breakfast nook,& walk-in pantry. The versatile floor plan offers 2 en-suite bedrooms on the ground level,& 2 more en-suite bedrooms upstairs,including a spacious primary suite w/ luxurious spa-like bathroom featuring soaking jetted tub,fireplace kitchenette,& sitting room,all overlooking the veranda & serene rear yard.The grand mahogany wood-textured office library is perfect for working from home, w/ exquisite built-in cabinetry,beautiful inlaid wood flooring & a private entrance for clients.The back staircase leads to the recreation room,craft-r" "UploadedDateTime" => "2023-04-14T08:58:27-07:00" "ModificationTimestamp" => "2023-09-30T18:01:54-07:00" "ResourceRecordKeyNumeric" => 560492024 "OriginatingSystemMediaKey" => "MLS Metrolist" ] 1 => array:15 [ "Order" => 2 "MediaKey" => "560492024_f3bb9131-2cbc-485c-ab7c-28efaaf25bdf.jpg" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/44/560492024/6a82fa9a3162dd6e70b0be2ad291311f.jpg" "MLSOrigin" => "MLS Metrolist" "MediaSize" => 142574 "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/44/560492024/thumbnail-6a82fa9a3162dd6e70b0be2ad291311f.jpg" "ImageWidth" => 900 "Permission" => "Public" "ImageHeight" => 600 "ThumbnailURL" => "https://mediarem.metrolist.net/metrolist/listingpics/tmbphoto/2023/04/14/f3bb9131-2cbc-485c-ab7c-28efaaf25bdf.jpg" "LongDescription" => "Welcome to this prestigious private gated estate in highly coveted Sierra Oaks Vista. Luxurious landscape designed by Michael Glassman, where you can relax, entertain, and garden! apprx 0.76 lot. 2 bedrooms’ downstairs each with full bath ensuites. Upstairs 2 bedroom ensuites. Huge Primary ensuite with luxurious spa like bathroom with soaking jetted tub. Fireplace & private kitchenette. master sitting room. The veranda overlooking rear yard." "UploadedDateTime" => "2023-04-14T08:58:27-07:00" "ModificationTimestamp" => "2023-09-30T18:01:55-07:00" "ResourceRecordKeyNumeric" => 560492024 "OriginatingSystemMediaKey" => "MLS Metrolist" ] ] +"ID": "31347" }
Active
Adams Road, Sacramento, CA 95864
Adams Road, Sacramento, CA 95864
Overview
Property ID: 223027453
- Condo, Residential
- 2
- 1
- 4.0
Description
**This listings is for DEMO/TEST purpose only** Welcome to luxury Brightwater Towers Condo, where style and value meet by the beach! This exclusive apartment is located on the second floor of the elevator building and features impeccable, recent renovation. The moment you step in into this beautiful, sun-drenched 2 bedrooms, 1 bath with huge balc ** To get a real data, please visit https://dashboard.realtyfeed.com
Address
Open on Google Maps- Address Adams Road
- City Sacramento
- State/county CA
- Zip/Postal Code 95864
Details
Updated on January 24, 2024 at 9:20 am- Property ID: 223027453
- Price: $614,900
- Land Area: 0.7634 Acres
- Bedrooms: 2
- Bathroom: 1
- Garages: 4.0
- Garage Size: x x
- Property Type: Condo, Residential
- Property Status: Active
Additional details
- Roof: Tile
- Utilities: Cable Available,Electric
- Sewer: In & Connected
- Cooling: Ceiling Fan(s),Central,MultiUnits,MultiZone
- Heating: Central,MultiUnits,MultiZone
- Flooring: Carpet,Stone,Wood
- County: Sacramento
- Property Type: Residential
- Pool: Built-In,Pool/Spa Combo
- Parking: Attached,RV Garage Attached
- Architectural Style: Mediterranean
Features
Mortgage Calculator
Monthly
- Down Payment
- Loan Amount
- Monthly Mortgage Payment
- Property Tax
- Home Insurance
- PMI
- Monthly HOA Fees