Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Cache Key: 7bc45d65f79071de73d3a7ebf1647bf66070946764c916c4827ee78180fb4915" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4916 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3983 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1111903809" +"ListingId": "NP25085027" +"PropertyType": "Residential" +"PropertySubType": "Townhouse" +"StandardStatus": "Active Under Contract" +"ModificationTimestamp": "2025-06-15T00:15:09Z" +"RFModificationTimestamp": "2025-06-15T01:05:02.412999+00:00" +"ListPrice": 839999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 2.0 +"LotSizeArea": 1274.0 +"LivingArea": 1368.0 +"BuildingAreaTotal": 0 +"City": "Costa Mesa" +"PostalCode": "92627" +"UnparsedAddress": "2218 Mayfair Court, Costa Mesa, California 92627" +"Coordinates": array:2 [ …2] +"Latitude": 33.654983 +"Longitude": -117.907899 +"YearBuilt": 1981 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Mark Todd" +"ListOfficeName": "Compass" +"ListAgentMlsId": "U10487" +"ListOfficeMlsId": "NP60725" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "With 2 large ensuite bedrooms, a bonus room (perfect for a home office, gym, or guest room), and a main-floor powder, this centrally located Costa Mesa townhome offers comfort, style, and convenience in every corner. Discover a fully renovated interior featuring a new kitchen with quartz countertops, self-closing drawers, and a newly added pantry. Enjoy custom paint, new baseboards that complement the crown molding, new flooring, and upgraded stairs and railings throughout. Newly installed recessed canned lighting enhances the bright, open layout. The cozy living room with fireplace opens to a private side yard, perfect for relaxing or letting pets play. A balcony off the dining area is ideal for morning coffee or evening wine. Upstairs laundry adds everyday convenience, and the epoxy-coated 2-car garage with direct access completes this truly turnkey home. The home also had newly installed HVAC and tankless water heater systems. Garden Park Village is just minutes from Costa Mesa’s best shopping, dining, local parks, and freeway access, offering a convenient lifestyle in one of Orange County’s most sought-after neighborhoods. Enjoy life at its best where residents have access to a resort-style pool and spa that is perfect for unwinding after a long day. Whether you're a first-time buyer, investor, or simply ready to buy a home with everything and needs nothing other than your personal belongings, this is your opportunity. Don’t miss your chance to own this immaculate, move-in-ready townhome in the Heart of Costa Mesa!" +"AccessibilityFeatures": "Low Pile Carpet,Accessible Doors" +"ActivationDate": "2025-04-19" +"Appliances": "Gas Oven,Gas Range,Refrigerator,Range Hood,Tankless Water Heater,Vented Exhaust Fan" +"ArchitecturalStyle": "Bungalow,Cape Cod,Cottage" +"AssociationAmenities": "Pool,Spa/Hot Tub" +"AssociationFee": "490.0" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": "Pest Control" +"AssociationName": "Garden Park Village" +"AssociationPhone": "7145055400" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "949-514-0000" +"Basement": "Finished" +"BasementYN": true +"BathroomsFull": 2 +"CLIP": 7147845806 +"CommonInterest": "Condominium" +"CommonWalls": "1 Common Wall" +"CommunityFeatures": "Curbs" +"ConstructionMaterials": "Stucco,Vinyl Siding,Wood Siding" +"ContractStatusChangeDate": "2025-06-07" +"Cooling": "Central Air,High Efficiency" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-04-19T13:20:15.326911+00:00" +"CumulativeDaysOnMarket": 56 +"CurrentFinancing": "Conventional" +"DaysOnMarket": 56 +"DaysOnMarketReplication": 56 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"DirectionFaces": "West" +"Directions": "Fairview Dr (SOUTH), RIGHT Mayfair Lane, LEFT Mayfair Court." +"Disclosures": "Covenants/Restrictions Disclosure,HOA Disclosure" +"DocumentsChangeTimestamp": "2025-04-26T09:59:22Z" +"DoorFeatures": "Sliding Doors" +"Electric": "Standard" +"ElevationUnits": "Feet" +"EntryLevel": 2 +"EntryLocation": "2" +"Exclusions": "Washer & Dryer" +"ExteriorFeatures": "Rain Gutters" +"Fencing": "Vinyl" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"Flooring": "Laminate, Vinyl" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central,Fireplace(s),Natural Gas,Wood" +"HeatingYN": true +"HighSchoolDistrict": "Newport Mesa Unified" +"InteriorFeatures": "Wet Bar,Block Walls,Ceiling Fan(s),Crown Molding,Cathedral Ceiling(s),Separate/Formal Dining Room,High Ceilings,Quartz Counters,Bar,All Bedrooms Up,Multiple Primary Suites,Primary Suite,Utility Room,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Electric Dryer Hookup,Gas Dryer Hookup,Inside,Laundry Closet,Upper Level" +"Levels": "Three Or More" +"ListAgentAOR": "Newport" +"ListAgentDirectPhone": "949-514-0000" +"ListAgentEmail": "mark.todd@compass.com" +"ListAgentFirstName": "Mark" +"ListAgentKey": "17011730" +"ListAgentKeyNumeric": "17011730" +"ListAgentLastName": "Todd" +"ListAgentOfficePhone": "949-438-4340" +"ListAgentStateLicense": "01168021" +"ListAgentURL": "www.marktoddandassociates.com" +"ListAgentVoiceMailExt": "0" +"ListOfficeAOR": "Newport" +"ListOfficeEmail": "kathy@compass.com" +"ListOfficeFax": "949-335-7281" +"ListOfficeKey": "3288694" +"ListOfficeKeyNumeric": "3288694" +"ListOfficePhone": "949-438-4340" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-16" +"ListingKeyNumeric": 1111903809 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to Existing Loan,Cash to New Loan,Conventional,Cal Vet Loan,FHA,Fannie Mae,Freddie Mac,Government Loan,Lease Back,Lease Option,Owner Will Carry,Owner May Carry,Owner Pay Points,Private Financing Available" +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard,No Landscaping,Rectangular Lot,Yard,Zero Lot Line" +"LotSizeAcres": 0.0292 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 1274.0 +"MLSAreaMajor": "C4 - Central Costa Mesa" +"MajorChangeTimestamp": "2025-06-09T12:13:39Z" +"MajorChangeType": "Active Under Contract" +"MlsStatus": "Active Under Contract" +"NumberOfUnitsInCommunity": 18 +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OnMarketDate": "2025-04-19" +"OnMarketTimestamp": "2025-04-19T00:30:32Z" +"OriginalEntryTimestamp": "2025-04-17T22:25:00Z" +"OriginalListPrice": 888999.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374262581" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "41901329" +"ParkingFeatures": "Asphalt,Direct Access,Driveway Level,Door-Single,Garage Faces Front,Garage,Guest,On Site,Off Street,Paved,Permit Required,Public,One Space" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Concrete, Patio" +"PhotosChangeTimestamp": "2025-05-16T05:29:40Z" +"PhotosCount": 44 +"PoolFeatures": "In Ground,Association" +"Possession": "Close Of Escrow,See Remarks" +"PostalCodePlus4": "1675" +"PreviousListPrice": 888999.0 +"PriceChangeTimestamp": "2025-05-16T18:40:40Z" +"PropertyAttachedYN": true +"PropertyCondition": "Turnkey" +"PropertySubTypeAdditional": "Townhouse" +"PurchaseContractDate": "2025-06-07" +"RoadFrontageType": "City Street" +"RoadSurfaceType": "Paved" +"Roof": "Asphalt" +"RoomType": "Bonus Room,Bedroom,Basement,Entry/Foyer,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Office,Other,Utility Room,Dining Room" +"SecurityFeatures": "Fire Sprinkler System,Smoke Detector(s)" +"Sewer": "Public Sewer" +"ShowingContactName": "Mark Todd" +"ShowingContactPhone": "9495140000" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1111903809" +"SpaFeatures": "Association,In Ground" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StartShowingDate": "2025-04-19" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-09T12:13:39Z" +"StoriesTotal": "3" +"StreetName": "Mayfair" +"StreetNumber": "2218" +"StreetNumberNumeric": "2218" +"StreetSuffix": "Court" +"StructureType": "House" +"SubdivisionName": "Garden Park Village (GPKV)" +"TaxLot": "29" +"UniversalPropertyId": "US-06059-N-41901329-R-N" +"Utilities": "Cable Connected,Electricity Connected,Natural Gas Connected,Phone Connected,Sewer Connected,Water Connected" +"View": "None" +"VirtualTourURLBranded": "https://www.homes.com/property/2218-mayfair-ct-costa-mesa-ca/dyd5pjgspq3md/?tab=1&dk=1hndz4sggdqwm" +"VirtualTourURLUnbranded": "https://www.heyethica.com/videos/video_808e3372-27c1-4ed1-b1cf-84501ab00fe2?type=preview" +"VirtualTourURLUnbranded2": "https://www.homes.com/property/2218-mayfair-ct-costa-mesa-ca/dyd5pjgspq3md/?tab=1&dk=1hndz4sggdqwm" +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows,Plantation Shutters" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "All Bedrooms Up,Basement,Bonus Room,Entry,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Primary Suite,Office,Two Primaries,Utility Room,Walk-In Closet",\n "RoomKitchenFeatures": "Pots \u0026 Pan Drawers,Quartz Counters,Remodeled Kitchen,Self-closing cabinet doors",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1111903809",\n "EatingArea": "Dining Room",\n "RoomBathroomFeatures": "Bathtub,Shower,Double Sinks in Primary Bath,Dual shower heads (or Multiple),Exhaust fan(s),Soaking Tub,Vanity area,Walk-in shower",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1111903809')" +"CurrentPrice": 839999.0 +"provider_name": "CRMLS" +"RecordSignature": -1043238865 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:41901329" +"CountrySubdivision": "06059" +"PreviousStandardStatus": "Active" +"OriginatingSystemListOfficeKey": "80981310" +"OriginatingSystemListAgentMemberKey": "298358" +"Media": array:44 [ …44] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3984 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112011985" +"ListingId": "OC25087566" +"PropertyType": "Residential Income" +"PropertySubType": "Duplex" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T00:15:09Z" +"RFModificationTimestamp": "2025-06-15T01:04:26.644738+00:00" +"ListPrice": 1475000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 6039.0 +"LivingArea": 0 +"BuildingAreaTotal": 1786.0 +"City": "Costa Mesa" +"PostalCode": "92627" +"UnparsedAddress": "653 Joann Street, Costa Mesa, California 92627" +"Coordinates": array:2 [ …2] +"Latitude": 33.657333 +"Longitude": -117.926027 +"YearBuilt": 1958 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Alejandro Llamas" +"ListOfficeName": "Seven Gables Real Estate" +"ListAgentMlsId": "OCLLAMALE" +"ListOfficeMlsId": "J00451" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Discover an exceptional opportunity to own a versatile and spacious property in the heart of vibrant Costa Mesa! This charming 4-bedroom, 2-bathroom single-family home, complemented by an attached Studio (Accessory Dwelling Unit), offers endless possibilities for modern living, investment, or multi-generational households. This vacant gem is ready for its new owners to make it their own. Main Residence: Step into the inviting main home, featuring 4 generously sized bedrooms and 2 bathrooms. he functional floor plan includes spacious living areas, a dedicated dining space, and a kitchen ready to be transformed into your culinary haven. The French doors in the kitchen lead out to the covered patio and expansive backyard. The attached studio apartment is a standout feature, offering a fully independent living space ideal for rental income, guests, or extended family. This thoughtfully designed ADU includes a modern kitchen, a cozy dining area, a comfortable sleeping area, a roomy closet, and a full bathroom. The ADU provides a self-contained retreat with all the essentials, perfect for privacy and convenience. Shared Amenities: Both the main home and ADU benefit from a common laundry area, ensuring practicality and ease for all residents. The shared space is designed for efficiency, making daily chores a breeze. The Costa Mesa climate is perfect for year-round outdoor enjoyment. Nestled in the sought-after city of Costa Mesa, this home is minutes from world-class amenities and Southern California’s iconic lifestyle. Enjoy proximity to: South Coast Plaza, a premier shopping destination with luxury boutiques, dining, and entertainment. Top-rated schools within the Newport-Mesa Unified School District, ideal for families. Easy access to the 55, 405, and 73 freeways, connecting you to Orange County’s employment hubs and beyond. Why 653 Joann Street? This property combines the best of Costa Mesa’s laid-back coastal vibe with urban convenience, offering a rare chance to own a home with an income-producing ADU in a prime location. Whether you’re a homeowner seeking flexibility, an investor eyeing rental potential, or a family looking for space to grow, this property delivers unmatched value. Schedule a showing today to explore the endless possibilities at 653 Joann Street, Costa Mesa, CA 92627—your Costa Mesa dream home awaits!" +"Appliances": "Dryer, Washer" +"AttributionContact": "714-747-2035" +"BackOnMarketDate": "2025-04-26" +"BuildingAreaUnits": "Square Feet" +"CLIP": 7309134110 +"CommonInterest": "None" +"CommonWalls": "1 Common Wall" +"CommunityFeatures": "Curbs,Gutter(s),Storm Drain(s),Street Lights,Suburban" +"Contingency": "No Seller Contingencies" +"ContractStatusChangeDate": "2025-04-19" +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-04-26T14:13:52.981241+00:00" +"CumulativeDaysOnMarket": 49 +"CurrentFinancing": "Conventional" +"DaysOnMarket": 49 +"DaysOnMarketReplication": 49 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"DirectionFaces": "North" +"Directions": "Major Intersection: Wilson Street and Harbor Blvd. Head WEST on Wilson Street; head NORTH on Meyer Place; head WEST on Joann Street." +"DocumentsChangeTimestamp": "2025-05-05T19:36:22Z" +"DocumentsCount": 9 +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front of home / On the side for ADU" +"Exclusions": "Staging furniture and accessories" +"GardenerExpense": 1800.0 +"GrossScheduledIncome": 95400.0 +"Inclusions": "Refrigerators (2) and Washer and Dryer" +"InsuranceExpense": 4000.0 +"InteriorFeatures": "All Bedrooms Down" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Common Area,Inside,Laundry Room" +"Levels": "One" +"ListAgentAOR": "Orange County" +"ListAgentDirectPhone": "7147472035" +"ListAgentEmail": "alexl@sevengables.com" +"ListAgentFax": "714-731-4906" +"ListAgentFirstName": "Alejandro" +"ListAgentKey": "17273527" +"ListAgentKeyNumeric": "17273527" +"ListAgentLastName": "Llamas" +"ListAgentOfficePhone": "714-731-3777" +"ListAgentOfficePhoneExt": "0" +"ListAgentStateLicense": "01947540" +"ListAgentURL": "www.alexpllamas.com" +"ListOfficeAOR": "Orange County" +"ListOfficeFax": "714-731-4906" +"ListOfficeKey": "3279163" +"ListOfficeKeyNumeric": "3279163" +"ListOfficePhone": "714-731-3777" +"ListOfficePhoneExt": "0" +"ListOfficeURL": "www.sevengables.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-19" +"ListingKeyNumeric": 1112011985 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan" +"LotFeatures": "Lawn,Landscaped,Level,Rectangular Lot,Street Level,Yard" +"LotSizeAcres": 0.1386 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 6039.0 +"MLSAreaMajor": "C2 - Southwest Costa Mesa" +"MajorChangeTimestamp": "2025-04-26T06:54:49Z" +"MajorChangeType": "Back On Market" +"MlsStatus": "Active" +"NetOperatingIncome": 75400.0 +"NumberOfBuildings": 1 +"NumberOfSeparateElectricMeters": 1 +"NumberOfSeparateGasMeters": 1 +"NumberOfSeparateWaterMeters": 1 +"NumberOfUnitsTotal": "2" +"OffMarketDate": "2025-04-21" +"OffMarketTimestamp": "2025-04-21T19:22:56Z" +"OnMarketDate": "2025-04-21" +"OnMarketTimestamp": "2025-04-26T06:54:49Z" +"OpenParkingSpaces": "3.0" +"OperatingExpense": "20000.0" +"OriginalEntryTimestamp": "2025-04-21T17:34:23Z" +"OriginalListPrice": 1475000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374275044" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "42215208" +"ParkingFeatures": "Driveway" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2025-05-06T02:46:40Z" +"PhotosCount": 32 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PostalCodePlus4": "5995" +"PropertyAttachedYN": true +"PropertySubTypeAdditional": "Duplex" +"RoomType": "Bedroom" +"Sewer": "Public Sewer" +"ShowingContactName": "Alejandro P. Llamas" +"ShowingContactPhone": "(714) 747-2035" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112011985" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-04-26T06:54:49Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Joann" +"StreetNumber": "653" +"StreetNumberNumeric": "653" +"StreetSuffix": "Street" +"SubdivisionName": "Westside Costa Mesa Central (WCMC)" +"TaxLot": "29" +"TenantPays": "Cable TV,Electricity,Gas,Telephone" +"TrashExpense": 324.0 +"UniversalPropertyId": "US-06059-N-42215208-R-N" +"VacancyAllowanceRate": 5.0 +"VirtualTourURLBranded": "www.653joannstreet.com" +"WalkScore": 60 +"WaterSewerExpense": 780.0 +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down",\n "AdminUpdateYN": "0",\n "ListingKey": "1112011985",\n "DPResourceYN": "1"\n } """ +"TaxAuthority": "15039" +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112011985')" +"CurrentPrice": 1475000.0 +"provider_name": "CRMLS" +"RecordSignature": 2063516778 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:42215208" +"CountrySubdivision": "06059" +"PreviousStandardStatus": "Hold" +"OriginatingSystemListOfficeKey": "90618" +"OriginatingSystemListAgentMemberKey": "6289401" +"Media": array:32 [ …32] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4008 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1111925298" +"ListingId": "OC25074796" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T00:09:44Z" +"RFModificationTimestamp": "2025-06-15T01:06:43.866818+00:00" +"ListPrice": 1450000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 1766.0 +"LivingArea": 1780.0 +"BuildingAreaTotal": 0 +"City": "Costa Mesa" +"PostalCode": "92627" +"UnparsedAddress": "334 Tours Lane, Costa Mesa, California 92627" +"Coordinates": array:2 [ …2] +"Latitude": 33.653494 +"Longitude": -117.893214 +"YearBuilt": 1965 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Shelly Cofini" +"ListOfficeName": "Berkshire Hathaway HomeService" +"ListAgentMlsId": "OCCOFISHE" +"ListOfficeMlsId": "S604" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Welcome to 334 Tours Lane, a beautifully remodeled attached SFR in Eastside Costa Mesa's heart. This spacious 4-bedroom, 2.5-bathroom home offers 1,764 square feet of living space on a 1,780-square-foot lot, combining modern upgrades with coastal charm. Built in 1965, this property has been thoughtfully updated to meet the needs of today’s homeowner. Step inside to discover a bright, airy interior featuring recessed lighting, stone and vinyl flooring, and a cozy gas fireplace in the living room. The newly renovated kitchen boasts quartz countertops, stainless steel appliances, and ample storage space. Upstairs, you’ll find all four bedrooms, ensuring privacy and functionality for your family or guests. Central air conditioning provides year-round comfort. Outside, enjoy a private patio complete with a built-in fire pit—perfect for entertaining or unwinding after a long day. The attached two-car garage includes washer/dryer hookups for added convenience. As part of the community, residents have access to exceptional amenities including two tennis courts, a junior Olympic-sized swimming pool, a spa, recreation rooms, and picnic areas. Located just minutes from Newport Back Bay’s scenic trails and close to major freeways (55, 73, and 405), John Wayne Airport, Newport Beach, South Coast Plaza, Fashion Island, Hoag Hospital, and UCI, this home is ideally situated for both work and play. Zoned within the Newport Mesa Unified School District with highly rated schools nearby. Don’t miss this opportunity to own a turnkey property in one of Costa Mesa’s most desirable neighborhoods!" +"AccessibilityFeatures": "Accessible Doors" +"Appliances": "6 Burner Stove,Dishwasher,Gas Cooktop,Disposal,Gas Range,Gas Water Heater,Ice Maker,Microwave,Refrigerator" +"ArchitecturalStyle": "Bungalow" +"AssociationAmenities": "Billiard Room,Fitness Center,Maintenance Grounds,Game Room,Meeting Room,Meeting/Banquet/Party Room,Outdoor Cooking Area,Barbecue,Picnic Area,Pickleball,Pool,Spa/Hot Tub,Tennis Court(s)" +"AssociationFee": "421.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "Back Bay Gardens" +"AssociationPhone": "949-900-2668" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "949-922-3698" +"BathroomsFull": 2 +"CLIP": 2490736675 +"CoListAgentAOR": "Orange County" +"CoListAgentEmail": "amy@amysessner.com" +"CoListAgentFirstName": "Amy" +"CoListAgentFullName": "Amy Sessner" +"CoListAgentKey": "17276883" +"CoListAgentKeyNumeric": "17276883" +"CoListAgentLastName": "Sessner" +"CoListAgentMlsId": "ocsessamy" +"CoListAgentOfficePhone": "949-644-6200" +"CoListAgentOfficePhoneExt": "0" +"CoListAgentStateLicense": "01261158" +"CoListOfficeAOR": "Orange County" +"CoListOfficeFax": "949-640-7429" +"CoListOfficeKey": "3288649" +"CoListOfficeKeyNumeric": "3288649" +"CoListOfficeMlsId": "S604" +"CoListOfficeName": "Berkshire Hathaway HomeService" +"CoListOfficePhone": "949-644-6200" +"CoListOfficePhoneExt": "0" +"CommonInterest": "Planned Development" +"CommonWalls": "2+ Common Walls" +"CommunityFeatures": "Biking,Curbs,Park,Preserve/Public Land,Storm Drain(s),Street Lights,Sidewalks,Pool" +"ConstructionMaterials": "Stucco" +"ContractStatusChangeDate": "2025-04-01" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-04-18T21:11:11.992290+00:00" +"CumulativeDaysOnMarket": 57 +"CurrentFinancing": "Conventional" +"DaysOnMarket": 57 +"DaysOnMarketReplication": 57 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Irvine Avenue to Monte Vista. Left on Rue De Cannes to Tours lane" +"Disclosures": "Covenants/Restrictions Disclosure,HOA Disclosure" +"DoorFeatures": "Mirrored Closet Door(s)" +"Electric": "220 Volts in Garage,220 Volts in Kitchen" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1st level" +"ExteriorFeatures": "Lighting,Rain Gutters" +"Fencing": "Block" +"FireplaceFeatures": "Gas,Living Room" +"FireplaceYN": true +"Flooring": "Laminate, Stone" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchool": "Newport Harbor" +"HighSchoolDistrict": "Newport Mesa Unified" +"Inclusions": "Refrigerator and Washer & Dryer" +"InteriorFeatures": "Breakfast Bar,Ceiling Fan(s),Ceramic Counters,Eat-in Kitchen,Recessed Lighting,All Bedrooms Up,Primary Suite" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"Levels": "Two" +"ListAgentAOR": "Orange County" +"ListAgentEmail": "shellycofini@bhhscal.com" +"ListAgentFax": "9495657815" +"ListAgentFirstName": "Shelly" +"ListAgentKey": "17271027" +"ListAgentKeyNumeric": "17271027" +"ListAgentLastName": "Cofini" +"ListAgentOfficePhone": "949-644-6200" +"ListAgentOfficePhoneExt": "0" +"ListAgentStateLicense": "01080698" +"ListAgentURL": "www.carlisleandcofini.com" +"ListOfficeAOR": "Orange County" +"ListOfficeFax": "949-640-7429" +"ListOfficeKey": "3288649" +"ListOfficeKeyNumeric": "3288649" +"ListOfficePhone": "949-644-6200" +"ListOfficePhoneExt": "0" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-01" +"ListingKeyNumeric": 1111925298 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan,Conventional" +"LivingAreaSource": "Assessor" +"LotDimensionsSource": "Assessor" +"LotFeatures": "Close to Clubhouse,Paved,Sprinklers Timer,Yard" +"LotSizeAcres": 0.0405 +"LotSizeDimensions": "1766" +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 1766.0 +"MLSAreaMajor": "C5 - East Costa Mesa" +"MainLevelBathrooms": 1 +"MajorChangeTimestamp": "2025-06-12T15:37:14Z" +"MajorChangeType": "Price Change" +"MiddleOrJuniorSchool": "Ensign" +"MlsStatus": "Active" +"NumberOfUnitsInCommunity": 164 +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OnMarketDate": "2025-04-18" +"OnMarketTimestamp": "2025-04-18T11:13:26Z" +"OriginalEntryTimestamp": "2025-04-18T11:13:26Z" +"OriginalListPrice": 1500000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374264514" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "43914202" +"ParkingFeatures": "Direct Access,Door-Single,Garage Faces Front,Garage,Garage Door Opener,Paved,Permit Required" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Concrete, Deck, Open, Patio" +"PhotosChangeTimestamp": "2025-04-22T23:55:46Z" +"PhotosCount": 41 +"PoolFeatures": "Community,Electric Heat,In Ground,Association" +"Possession": "Close Of Escrow" +"PostalCodePlus4": "1434" +"PreviousListPrice": 1475000.0 +"PriceChangeTimestamp": "2025-06-12T15:37:14Z" +"PropertyAttachedYN": true +"PropertyCondition": "Updated/Remodeled" +"PropertySubTypeAdditional": "Single Family Residence" +"RoadFrontageType": "City Street" +"RoadSurfaceType": "Paved" +"Roof": "Composition" +"RoomType": "Bedroom,Family Room,Kitchen,Living Room,Primary Bedroom" +"SecurityFeatures": "Carbon Monoxide Detector(s),Smoke Detector(s)" +"Sewer": "Public Sewer" +"ShowingContactName": "Amy Sessner" +"ShowingContactPhone": "949-463-1409" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1111925298" +"SpaFeatures": "Association,Community,Heated,In Ground" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-04-18T11:13:26Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Tours" +"StreetNumber": "334" +"StreetNumberNumeric": "334" +"StreetSuffix": "Lane" +"StructureType": "House" +"SubdivisionName": "Newport Riviera (ENNR)" +"TaxLot": "63" +"UniversalPropertyId": "US-06059-N-43914202-R-N" +"Utilities": "Cable Available,Electricity Connected,Natural Gas Connected,Phone Available,Sewer Connected,Water Connected" +"View": "None" +"VirtualTourURLUnbranded": "https://www.dropbox.com/scl/fi/rz54jhpbmgoyv3yyavlwx/334-Tours-Ln Promo.mp4?rlkey=1hfksjqi312qldnkchb8ou272&dl=0" +"WaterSource": "Public" +"WindowFeatures": "Shutters" +"YearBuiltSource": "Assessor" +"Zoning": "R1" +"CustomFields": """ {\n "RoomType": "All Bedrooms Up,Family Room,Kitchen,Living Room,Primary Suite",\n "EatingArea": "Breakfast Counter / Bar,In Kitchen",\n "RoomKitchenFeatures": "Built-in Trash/Recycling,Kitchen Open to Family Room,Quartz Counters,Remodeled Kitchen,Self-closing drawers",\n "RoomBathroomFeatures": "Shower,Shower in Tub,Closet in bathroom,Double Sinks in Primary Bath,Remodeled,Stone Counters,Upgraded,Vanity area,Walk-in shower",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1111925298",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1111925298')" +"CurrentPrice": 1450000.0 +"provider_name": "CRMLS" +"RecordSignature": -1960271871 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:43914202" +"CountrySubdivision": "06059" +"OriginatingSystemListOfficeKey": "55489" +"OriginatingSystemCoListOfficeKey": "55489" +"OriginatingSystemListAgentMemberKey": "558600" +"OriginatingSystemCoListAgentMemberKey": "560732" +"Media": array:41 [ …41] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4009 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1108348500" +"ListingId": "NP25031147" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T00:00:12Z" +"RFModificationTimestamp": "2025-06-15T01:07:38.076687+00:00" +"ListPrice": 2995000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 6320.0 +"LivingArea": 2298.0 +"BuildingAreaTotal": 0 +"City": "Costa Mesa" +"PostalCode": "92627" +"UnparsedAddress": "223 Robinhood Place, Costa Mesa, California 92627" +"Coordinates": array:2 [ …2] +"Latitude": 33.644671 +"Longitude": -117.908362 +"YearBuilt": 1959 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Mark Taylor" +"ListOfficeName": "Compass" +"ListAgentMlsId": "U40899" +"ListOfficeMlsId": "NP60725" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Your modern, coastal dream home awaits, 223 Robin Hood Place is perfectly situated at the end of a secluded cul-de-sac in Eastside Costa Mesa. Ideal for entertaining and thoughtfully designed for everyday function and relaxation, this single-level home offers 2,298 square feet of living space, expertly crafted in 2011 by one of Orange County’s premier custom home builders as a personal residence. Stunning from the curb, the lush, recently redesigned landscape by award-winning Camille Beehler Design greets you with a serene outdoor space. Pass through the quintessential Southern California dutch door to find polished concrete floors and bright floating walls in harmony with glass doors, skylights, and nine-foot ceilings, creating an airy space bathed in natural light. The generous great room is the heart of the home featuring ceilings vaulted to twelve feet and massive sliding doors to both the front and back outdoor retreats, blurring the lines of indoor and outdoor living. The gourmet kitchen, updated in 2021, boasts sleek quartz countertops accented by an expansive waterfall island, premium stainless-steel appliances by Dacor and Miele, large walk-in pantry and bespoke lighting. The outdoor spaces are just as inviting, with a front deck and lush green space, a private backyard lounge with a built-in grill, TV and fire pit, and a secluded hot tub—ideal for unwinding under the stars. Dine al fresco under the charming pergola, complete with custom outdoor lighting. The primary suite is a private sanctuary with large casement windows, a custom walk-in closet, dual wardrobes, and an oversized built-in dresser. The spa-like primary bathroom is a true retreat, featuring naturally lit vanities, a dual-head shower, and a freestanding soaking tub framed by a tranquil view of mature bamboo, with direct outdoor access to the hot tub. Plus, it’s close to award-winning schools, Newport Back Bay, popular shops and restaurants of 17th street and so much more. Don’t miss your chance to own this exquisite gem in the heart of Eastside Costa." +"Appliances": "6 Burner Stove,Convection Oven,Double Oven,Dishwasher,Refrigerator,Range Hood" +"AttachedGarageYN": true +"AttributionContact": "949-335-8698" +"BackOnMarketDate": "2025-04-15" +"BathroomsFull": 3 +"CLIP": 4461841296 +"CoListAgentAOR": "Newport" +"CoListAgentEmail": "dmason@compass.com" +"CoListAgentFirstName": "Dylan" +"CoListAgentFullName": "Dylan Mason" +"CoListAgentKey": "17243600" +"CoListAgentKeyNumeric": "17243600" +"CoListAgentLastName": "Mason" +"CoListAgentMlsId": "U40329" +"CoListAgentOfficePhone": "949-438-4340" +"CoListAgentStateLicense": "01709074" +"CoListAgentURL": "www.yourcdmhome.com" +"CoListOfficeAOR": "Newport" +"CoListOfficeEmail": "kathy@compass.com" +"CoListOfficeFax": "949-335-7281" +"CoListOfficeKey": "3288694" +"CoListOfficeKeyNumeric": "3288694" +"CoListOfficeMlsId": "NP60725" +"CoListOfficeName": "Compass" +"CoListOfficePhone": "949-438-4340" +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs,Street Lights,Sidewalks" +"ContractStatusChangeDate": "2025-03-06" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-04-16T03:04:32.566082+00:00" +"CumulativeDaysOnMarket": 92 +"DaysOnMarket": 92 +"DaysOnMarketReplication": 92 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Westminster Ave and Robin Hood Place" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"ExteriorFeatures": "Fire Pit" +"FireplaceFeatures": "Outside" +"FireplaceYN": true +"Flooring": "Concrete" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Newport Mesa Unified" +"InteriorFeatures": "Breakfast Bar,Built-in Features,Separate/Formal Dining Room,Eat-in Kitchen,High Ceilings,Open Floorplan,Pantry,All Bedrooms Down,Main Level Primary,Walk-In Pantry,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside, Stacked" +"Levels": "One" +"ListAgentAOR": "Newport" +"ListAgentEmail": "marktaylor@compass.com" +"ListAgentFirstName": "Mark" +"ListAgentKey": "17261082" +"ListAgentKeyNumeric": "17261082" +"ListAgentLastName": "Taylor" +"ListAgentOfficePhone": "949-438-4340" +"ListAgentStateLicense": "01877391" +"ListAgentURL": "masontaylorproperties.com" +"ListOfficeAOR": "Newport" +"ListOfficeEmail": "kathy@compass.com" +"ListOfficeFax": "949-335-7281" +"ListOfficeKey": "3288694" +"ListOfficeKeyNumeric": "3288694" +"ListOfficePhone": "949-438-4340" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-03-06" +"ListingKeyNumeric": 1108348500 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional" +"LotFeatures": "Back Yard,Cul-De-Sac,Front Yard" +"LotSizeAcres": 0.1451 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 6320.0 +"MLSAreaMajor": "C5 - East Costa Mesa" +"MainLevelBathrooms": 3 +"MainLevelBedrooms": 4 +"MajorChangeTimestamp": "2025-05-09T12:54:49Z" +"MajorChangeType": "Price Change" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OffMarketDate": "2025-04-07" +"OffMarketTimestamp": "2025-04-07T12:46:37Z" +"OnMarketDate": "2025-03-06" +"OnMarketTimestamp": "2025-04-15T12:34:02Z" +"OriginalEntryTimestamp": "2025-03-06T13:28:20Z" +"OriginalListPrice": 3395000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374039781" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "42620248" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-04-27T15:59:15Z" +"PhotosCount": 29 +"PoolFeatures": "None" +"PostalCodePlus4": "2132" +"PreviousListPrice": 3295000.0 +"PriceChangeTimestamp": "2025-05-09T12:54:49Z" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Bedroom,Den,Kitchen,Living Room,Primary Bathroom,Primary Bedroom,Other,Pantry,Dining Room" +"Sewer": "Public Sewer" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1108348500" +"SpaFeatures": "Private" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-04-15T12:34:02Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Robinhood" +"StreetNumber": "223" +"StreetNumberNumeric": "223" +"StreetSuffix": "Place" +"StructureType": "House" +"SubdivisionName": "Eastside South (ESCM)" +"TaxLot": "17" +"UniversalPropertyId": "US-06059-N-42620248-R-N" +"View": "Neighborhood" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Den,Kitchen,Living Room,Main Floor Primary Bedroom,Primary Bathroom,Primary Bedroom,Walk-In Closet,Walk-In Pantry",\n "EatingArea": "Breakfast Counter / Bar,Dining Room,In Kitchen",\n "RoomKitchenFeatures": "Kitchen Island,Kitchen Open to Family Room,Walk-In Pantry",\n "RoomBathroomFeatures": "Bathtub,Shower,Shower in Tub,Double sinks in bath(s),Double Sinks in Primary Bath,Separate tub and shower",\n "AdminUpdateYN": "0",\n "ListingKey": "1108348500",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1108348500')" +"CurrentPrice": 2995000.0 +"provider_name": "CRMLS" +"RecordSignature": 522427497 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:42620248" +"CountrySubdivision": "06059" +"PreviousStandardStatus": "Hold" +"OriginatingSystemListOfficeKey": "80981310" +"OriginatingSystemCoListOfficeKey": "80981310" +"OriginatingSystemListAgentMemberKey": "314950" +"OriginatingSystemCoListAgentMemberKey": "296273" +"Media": array:29 [ …29] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4010 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112012859" +"ListingId": "OC25087613" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T00:00:12Z" +"RFModificationTimestamp": "2025-06-15T00:13:50.991675+00:00" +"ListPrice": 1475000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 6039.0 +"LivingArea": 1786.0 +"BuildingAreaTotal": 0 +"City": "Costa Mesa" +"PostalCode": "92627" +"UnparsedAddress": "653 Joann Street, Costa Mesa, California 92627" +"Coordinates": array:2 [ …2] +"Latitude": 33.657333 +"Longitude": -117.926027 +"YearBuilt": 1958 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Alejandro Llamas" +"ListOfficeName": "Seven Gables Real Estate" +"ListAgentMlsId": "OCLLAMALE" +"ListOfficeMlsId": "J00451" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Discover the perfect family home at 653 Joann Street, a 4-bedroom, 2-bathroom residence in the heart of Westside Costa Mesa, thoughtfully designed for multi-generational living. This charming single-story home boasts an attached Accessory Dwelling Unit (ADU)—a fully equipped studio apartment featuring a kitchen, dining area, spacious closet, and full bathroom, ideal for an adult child seeking independence while staying close to family. A shared laundry area conveniently serves both units, blending practicality with modern living. The main house offers four generously sized bedrooms and two bathrooms, providing ample space for family life. Bright and airy, the home is move-in ready, with a flexible layout perfect for personalization. Whether hosting family gatherings or enjoying quiet evenings, this property delivers comfort and versatility. Nestled in vibrant Westside Costa Mesa, this home is surrounded by family-friendly amenities. Top-rated schools, such as Grace Education and Pacific Academy Costa Mesa, are just minutes away, alongside public options like Estancia High School. Outdoor enthusiasts will love the proximity to Talbert Regional Park and pristine beaches, perfect for weekend adventures. Savor local flavors and immerse yourself in Costa Mesa’s “City of the Arts” culture with nearby art studios and music venues like The Wayfarer. With easy access to major highways and public transit, commuting is a breeze. Priced to sell in a sought-after neighborhood, 653 Joann Street is a rare opportunity for families seeking a spacious home with a private studio for an adult child. Don’t miss your chance to own this multi-generational gem in one of Costa Mesa’s most desirable communities—schedule a showing today!" +"Appliances": "Dryer, Washer" +"AttributionContact": "714-747-2035" +"BackOnMarketDate": "2025-04-26" +"BathroomsFull": 1 +"BathroomsThreeQuarter": 2 +"CLIP": 7309134110 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs,Storm Drain(s),Street Lights,Suburban,Sidewalks" +"Contingency": "No Seller Contingencies" +"ContractStatusChangeDate": "2025-04-19" +"Cooling": "None" +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-04-26T14:13:43.159017+00:00" +"CumulativeDaysOnMarket": 49 +"CurrentFinancing": "Conventional" +"DaysOnMarket": 49 +"DaysOnMarketReplication": 49 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Major Intersection: Wilson Street and Harbor Blvd. Head WEST on Wilson Street; head NORTH on Meyer Place; head WEST on Joann Street." +"Disclosures": "Accessory Dwelling Unit,Easement(s),Home Warranty" +"DocumentsChangeTimestamp": "2025-05-05T19:36:22Z" +"DocumentsCount": 9 +"ElementarySchool": "Adams" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front of Home" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"Flooring": "Vinyl" +"FoundationDetails": "Slab" +"Heating": "Central,Natural Gas" +"HeatingYN": true +"HighSchool": "Estancia" +"HighSchoolDistrict": "Newport Mesa Unified" +"InteriorFeatures": "All Bedrooms Up,Bedroom on Main Level,Galley Kitchen,Main Level Primary,Primary Suite" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Common Area,Washer Hookup,Gas Dryer Hookup,Laundry Room" +"Levels": "One" +"ListAgentAOR": "Orange County" +"ListAgentDirectPhone": "7147472035" +"ListAgentEmail": "alexl@sevengables.com" +"ListAgentFax": "714-731-4906" +"ListAgentFirstName": "Alejandro" +"ListAgentKey": "17273527" +"ListAgentKeyNumeric": "17273527" +"ListAgentLastName": "Llamas" +"ListAgentOfficePhone": "714-731-3777" +"ListAgentOfficePhoneExt": "0" +"ListAgentStateLicense": "01947540" +"ListAgentURL": "www.alexpllamas.com" +"ListOfficeAOR": "Orange County" +"ListOfficeFax": "714-731-4906" +"ListOfficeKey": "3279163" +"ListOfficeKeyNumeric": "3279163" +"ListOfficePhone": "714-731-3777" +"ListOfficePhoneExt": "0" +"ListOfficeURL": "www.sevengables.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-19" +"ListingKeyNumeric": 1112012859 +"ListingService": "Full Service" +"ListingTerms": "Cash to New Loan,Conventional" +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard,Front Yard,Lawn,Landscaped,Level,Rectangular Lot" +"LotSizeAcres": 0.1386 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 6039.0 +"MLSAreaMajor": "C2 - Southwest Costa Mesa" +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 4 +"MajorChangeTimestamp": "2025-04-26T06:55:03Z" +"MajorChangeType": "Back On Market" +"MiddleOrJuniorSchool": "Tewinkle" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "2" +"OccupantType": "Owner" +"OffMarketDate": "2025-04-21" +"OffMarketTimestamp": "2025-04-21T19:23:19Z" +"OnMarketDate": "2025-04-21" +"OnMarketTimestamp": "2025-04-26T06:55:03Z" +"OriginalEntryTimestamp": "2025-04-21T18:20:00Z" +"OriginalListPrice": 1475000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374275304" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "42215208" +"ParkingFeatures": "Driveway" +"PatioAndPorchFeatures": "Covered, Patio" +"PhotosChangeTimestamp": "2025-05-06T02:46:40Z" +"PhotosCount": 32 +"PoolFeatures": "None" +"Possession": "Close Of Escrow" +"PostalCodePlus4": "5995" +"PropertyCondition": "Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Bedroom,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom" +"SecurityFeatures": "Security System" +"Sewer": "Public Sewer" +"ShowingContactName": "Alejandro P. Llamas" +"ShowingContactPhone": "(714) 747-2035" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112012859" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-04-26T06:55:03Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Joann" +"StreetNumber": "653" +"StreetNumberNumeric": "653" +"StreetSuffix": "Street" +"StructureType": "House" +"SubdivisionName": "West Costa Mesa North (WNCM)" +"TaxLot": "29" +"UniversalPropertyId": "US-06059-N-42215208-R-N" +"Utilities": "Cable Available,Electricity Connected,Natural Gas Connected,Phone Available,Sewer Connected,Water Connected,Overhead Utilities" +"View": "None" +"VirtualTourURLBranded": "http://www.653joannstreet.com" +"WalkScore": 60 +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "All Bedrooms Up,Galley Kitchen,Kitchen,Laundry,Living Room,Main Floor Bedroom,Main Floor Primary Bedroom,Primary Bathroom,Primary Bedroom,Primary Suite",\n "EatingArea": "Area",\n "RoomKitchenFeatures": "Quartz Counters,Remodeled Kitchen",\n "RoomBathroomFeatures": "Shower,Walk-in shower",\n "AdminUpdateYN": "0",\n "ListingKey": "1112012859",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112012859')" +"CurrentPrice": 1475000.0 +"provider_name": "CRMLS" +"RecordSignature": 209366896 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:42215208" +"CountrySubdivision": "06059" +"PreviousStandardStatus": "Hold" +"OriginatingSystemListOfficeKey": "90618" +"OriginatingSystemListAgentMemberKey": "6289401" +"Media": array:32 [ …32] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4011 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112164215" +"ListingId": "NP25083475" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T00:00:12Z" +"RFModificationTimestamp": "2025-06-15T01:07:37.045893+00:00" +"ListPrice": 3995000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 7800.0 +"LivingArea": 2733.0 +"BuildingAreaTotal": 0 +"City": "Costa Mesa" +"PostalCode": "92627" +"UnparsedAddress": "459 E 18th Street, Costa Mesa, California 92627" +"Coordinates": array:2 [ …2] +"Latitude": 33.631989 +"Longitude": -117.9075 +"YearBuilt": 1948 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Mark Taylor" +"ListOfficeName": "Compass" +"ListAgentMlsId": "U40899" +"ListOfficeMlsId": "NP60725" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Welcome to BLKHOUZ on 18th Street — where heritage meets modern coastal living. This brand-new Eastside Costa Mesa home blends timeless charm with master craftsmanship, offering 4 bedrooms, 4.5 baths, and 2,733 sq ft of thoughtfully designed space, including a fully equipped ADU. Just steps from 17th Street shops, Newport’s Back Bay, and prime beaches, the home features Hemlock siding, an iron Dutch door, and 18-foot cathedral ceilings with skylights. The chef’s kitchen boasts white oak cabinetry, Viking appliances, handmade tile, and a slate island with Taj Mahal quartz. The living room's custom built-ins and volcanic stone fireplace create a warm, modern vibe flowing into a cozy California room. Step outside onto the beautiful hardwood deck accompanied by lush landscape, perfect for entertaining and enjoying sunsets by the beach-like fire pit. The luxurious primary suite includes dual walk-in closets, soaking tub, skylit shower, and spa-like finishes. Each bathroom offers unique designer touches. The ADU provides flexible living with a full kitchen, quartz counters, and chic main room. BLKHOUZ on 18th isn’t just a home — it’s a lifestyle rooted in the heart of Eastside Costa Mesa." +"Appliances": "6 Burner Stove,Built-In Range,Dishwasher,Refrigerator" +"AttributionContact": "949-335-8698" +"BackOnMarketDate": "2025-05-09" +"BathroomsFull": 4 +"CLIP": 5962491222 +"CoListAgentAOR": "Newport" +"CoListAgentEmail": "daniel.banuelos@compass.com" +"CoListAgentFirstName": "Daniel" +"CoListAgentFullName": "Daniel Banuelos" +"CoListAgentKey": "17247368" +"CoListAgentKeyNumeric": "17247368" +"CoListAgentLastName": "Banuelos" +"CoListAgentMlsId": "NP41736" +"CoListAgentOfficePhone": "949-438-4340" +"CoListAgentStateLicense": "02007567" +"CoListOfficeAOR": "Newport" +"CoListOfficeEmail": "kathy@compass.com" +"CoListOfficeFax": "949-335-7281" +"CoListOfficeKey": "3288694" +"CoListOfficeKeyNumeric": "3288694" +"CoListOfficeMlsId": "NP60725" +"CoListOfficeName": "Compass" +"CoListOfficePhone": "949-438-4340" +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Curbs, Sidewalks, Park" +"ContractStatusChangeDate": "2025-04-24" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-05-10T02:53:57.729058+00:00" +"CumulativeDaysOnMarket": 48 +"DaysOnMarket": 48 +"DaysOnMarketReplication": 48 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "18th and Irvine" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"ExteriorFeatures": "Fire Pit" +"FireplaceFeatures": "Living Room,Outside" +"FireplaceYN": true +"Flooring": "Wood" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Newport Mesa Unified" +"InteriorFeatures": "Built-in Features,Separate/Formal Dining Room,Eat-in Kitchen,High Ceilings,Living Room Deck Attached,Open Floorplan,All Bedrooms Down,Bedroom on Main Level,Main Level Primary" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Washer Hookup,Inside,Laundry Room" +"Levels": "One" +"ListAgentAOR": "Newport" +"ListAgentEmail": "marktaylor@compass.com" +"ListAgentFirstName": "Mark" +"ListAgentKey": "17261082" +"ListAgentKeyNumeric": "17261082" +"ListAgentLastName": "Taylor" +"ListAgentOfficePhone": "949-438-4340" +"ListAgentStateLicense": "01877391" +"ListAgentURL": "masontaylorproperties.com" +"ListOfficeAOR": "Newport" +"ListOfficeEmail": "kathy@compass.com" +"ListOfficeFax": "949-335-7281" +"ListOfficeKey": "3288694" +"ListOfficeKeyNumeric": "3288694" +"ListOfficePhone": "949-438-4340" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-24" +"ListingKeyNumeric": 1112164215 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional" +"LotFeatures": "0-1 Unit/Acre,Back Yard,Front Yard,Near Park" +"LotSizeAcres": 0.1791 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7800.0 +"MLSAreaMajor": "C5 - East Costa Mesa" +"MainLevelBathrooms": 3 +"MainLevelBedrooms": 4 +"MajorChangeTimestamp": "2025-05-09T19:29:13Z" +"MajorChangeType": "Back On Market" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OffMarketDate": "2025-05-06" +"OffMarketTimestamp": "2025-05-06T20:30:01Z" +"OnMarketDate": "2025-04-24" +"OnMarketTimestamp": "2025-05-09T19:29:13Z" +"OriginalEntryTimestamp": "2025-04-24T19:23:17Z" +"OriginalListPrice": 3995000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374301105" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "11737219" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-04-25T02:45:40Z" +"PhotosCount": 26 +"PoolFeatures": "None" +"PostalCodePlus4": "9622" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Bonus Room,Bedroom,Entry/Foyer,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Dining Room" +"Sewer": "Public Sewer" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112164215" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-09T19:29:13Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetDirPrefix": "E" +"StreetName": "18th" +"StreetNumber": "459" +"StreetNumberNumeric": "459" +"StreetSuffix": "Street" +"StructureType": "House" +"SubdivisionName": "Eastside Central (ECCM)" +"TaxLot": "2" +"UniversalPropertyId": "US-06059-N-11737219-R-N" +"View": "Neighborhood" +"ViewYN": true +"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=qdkb WKsyhn I" +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Bonus Room,Entry,Kitchen,Laundry,Living Room,Main Floor Bedroom,Main Floor Primary Bedroom,Primary Bathroom,Primary Bedroom",\n "EatingArea": "Dining Room,In Kitchen,Separated",\n "RoomKitchenFeatures": "Kitchen Island,Kitchen Open to Family Room,Remodeled Kitchen",\n "RoomBathroomFeatures": "Bathtub,Shower,Shower in Tub,Double Sinks in Primary Bath,Remodeled,Separate tub and shower,Upgraded",\n "AdminUpdateYN": "0",\n "ListingKey": "1112164215",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112164215')" +"CurrentPrice": 3995000.0 +"provider_name": "CRMLS" +"RecordSignature": -945375633 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:11737219" +"CountrySubdivision": "06059" +"PreviousStandardStatus": "Hold" +"OriginatingSystemListOfficeKey": "80981310" +"OriginatingSystemCoListOfficeKey": "80981310" +"OriginatingSystemListAgentMemberKey": "314950" +"OriginatingSystemCoListAgentMemberKey": "239297762" +"Media": array:26 [ …26] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4012 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1116210842" +"ListingId": "OC25123451" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T23:12:03Z" +"RFModificationTimestamp": "2025-06-15T00:26:29.359845+00:00" +"ListPrice": 1799999.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 7161.0 +"LivingArea": 1720.0 +"BuildingAreaTotal": 0 +"City": "Costa Mesa" +"PostalCode": "92626" +"UnparsedAddress": "2796 Cibola Avenue, Costa Mesa, California 92626" +"Coordinates": array:2 [ …2] +"Latitude": 33.674703 +"Longitude": -117.900205 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Matthew Kanoudi" +"ListOfficeName": "The L3" +"ListAgentMlsId": "SKANOMAT" +"ListOfficeMlsId": "H03205" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Welcome to 2796 Cibola Ave, a stunning single-story home situated on a coveted corner lot in the Mesa Del Mar neighborhood. The property greets you with a beautifully enclosed front yard, complete with a privacy fence and lush landscaping, leading to a delightful dutch door entrance. Inside, the home offers 1,720 square feet of elegant living space, including four bedrooms and two bathrooms. The main living area is a bright, open-concept space featuring a designer kitchen that flows seamlessly into the living room and dining area. High ceilings add volume, while a wet bar, equipped with a wine fridge and floating shelves, offers a touch of luxury. The kitchen itself is a masterpiece, featuring white oak cabinetry, a stylish tile backsplash, and a generous island topped with quartz countertops. Stainless steel appliances and an oversized sink add functionality, and pendant lighting provides a warm ambiance. Throughout the main areas and bedrooms, white oak hardwood flooring extends a sense of continuity and elegance.\r\r\n The master suite is completely private, situated separately from the other bedrooms. It features vaulted ceilings and a spacious walk-in closet. The en-suite bathroom impresses with a dual vanity topped with quartz and a large, custom walk-in shower. The three guest bedrooms are roomy and inviting, sharing a full bathroom with a dual vanity and a custom tiled shower-bathtub combination. The home also includes a brand new roof, an indoor laundry area, recessed lighting, and an effective air conditioning system for year-round comfort. The expansive backyard is a private retreat, offering a covered patio perfect for outdoor gatherings and relaxation. Ideally located near the OC Fairgrounds, shopping, golf courses, and dining, this home provides both comfort and convenience. Experience the exceptional lifestyle at 2796 Cibola Ave. """ +"Appliances": "6 Burner Stove,Built-In Range,Gas Cooktop,Disposal,Gas Oven,Gas Water Heater,Refrigerator,Vented Exhaust Fan" +"AttachedGarageYN": true +"AttributionContact": "714-655-6868" +"BathroomsFull": 1 +"BathroomsThreeQuarter": 1 +"CLIP": 8751915863 +"CoListAgentAOR": "Orange County" +"CoListAgentEmail": "colbyreedy@gmail.com" +"CoListAgentFirstName": "Colby" +"CoListAgentFullName": "Colby Reedy" +"CoListAgentKey": "25753525" +"CoListAgentKeyNumeric": "25753525" +"CoListAgentLastName": "Reedy" +"CoListAgentMlsId": "OCREEDYCO" +"CoListAgentOfficePhone": "714-444-4663" +"CoListAgentOfficePhoneExt": "0" +"CoListAgentStateLicense": "01943839" +"CoListOfficeAOR": "Orange County" +"CoListOfficeEmail": "mattkanoudi@gmail.com" +"CoListOfficeFax": "714-444-4223" +"CoListOfficeKey": "3288279" +"CoListOfficeKeyNumeric": "3288279" +"CoListOfficeMlsId": "H03205" +"CoListOfficeName": "The L3" +"CoListOfficePhone": "714-444-4663" +"CoListOfficePhoneExt": "0" +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Biking,Dog Park,Stable(s),Lake,Park,Street Lights,Sidewalks" +"ContractStatusChangeDate": "2025-06-10" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-06-11T06:25:58.966858+00:00" +"CumulativeDaysOnMarket": 4 +"DaysOnMarket": 4 +"DaysOnMarketReplication": 4 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Fairview and Adams" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"Fencing": "Privacy, Wood" +"FireplaceFeatures": "None" +"Flooring": "Tile, Wood" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchoolDistrict": "Newport Mesa Unified" +"InteriorFeatures": "Wet Bar,Breakfast Area,Eat-in Kitchen,High Ceilings,Open Floorplan,Quartz Counters,All Bedrooms Down,Main Level Primary" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Washer Hookup,Gas Dryer Hookup,Inside" +"Levels": "One" +"ListAgentAOR": "Orange County" +"ListAgentDirectPhone": "714-655-6868" +"ListAgentEmail": "mattkanoudi@gmail.com" +"ListAgentFax": "714-845-0180" +"ListAgentFirstName": "Matthew" +"ListAgentKey": "17276740" +"ListAgentKeyNumeric": "17276740" +"ListAgentLastName": "Kanoudi" +"ListAgentOfficePhone": "714-444-4663" +"ListAgentOfficePhoneExt": "0" +"ListAgentStateLicense": "01419924" +"ListAgentURL": "www.thekanoudigroup.com" +"ListAgentVoiceMailExt": "0" +"ListOfficeAOR": "Orange County" +"ListOfficeEmail": "mattkanoudi@gmail.com" +"ListOfficeFax": "714-444-4223" +"ListOfficeKey": "3288279" +"ListOfficeKeyNumeric": "3288279" +"ListOfficePhone": "714-444-4663" +"ListOfficePhoneExt": "0" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-06-10" +"ListingKeyNumeric": 1116210842 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan,Conventional,1031 Exchange,FHA,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard,Front Yard,Yard" +"LotSizeAcres": 0.1644 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7161.0 +"MLSAreaMajor": "C4 - Central Costa Mesa" +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 4 +"MajorChangeTimestamp": "2025-06-10T13:08:00Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Vacant" +"OnMarketDate": "2025-06-10" +"OnMarketTimestamp": "2025-06-10T13:08:00Z" +"OriginalEntryTimestamp": "2025-06-10T13:08:00Z" +"OriginalListPrice": 1799999.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374561888" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "14164323" +"ParkingFeatures": "Direct Access,Driveway,Garage,Garage Door Opener" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-11T06:19:41Z" +"PhotosCount": 29 +"PoolFeatures": "None" +"PostalCodePlus4": "5602" +"PropertyCondition": "Updated/Remodeled, Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition" +"RoomType": "Bedroom,Primary Bathroom,Primary Bedroom" +"Sewer": "Sewer Tap Paid" +"ShowingContactName": "Colby Reedy" +"ShowingContactPhone": "9494455562" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1116210842" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-10T13:08:00Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Cibola" +"StreetNumber": "2796" +"StreetNumberNumeric": "2796" +"StreetSuffix": "Avenue" +"StructureType": "House" +"SubdivisionName": "Mesa Del Mar (MDMA)" +"TaxLot": "62" +"UniversalPropertyId": "US-06059-N-14164323-R-N" +"View": "None" +"VirtualTourURLBranded": "http://www.2796cibola.com" +"VirtualTourURLUnbranded2": "http://www.2796cibola.com/mls/194159966" +"WaterSource": "Public" +"YearBuiltSource": "Public Records" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Main Floor Primary Bedroom,Primary Bathroom,Primary Bedroom",\n "EatingArea": "Breakfast Nook,Family Kitchen,In Kitchen",\n "RoomKitchenFeatures": "Kitchen Island,Kitchen Open to Family Room,Quartz Counters",\n "RoomBathroomFeatures": "Bathtub,Shower,Shower in Tub,Double sinks in bath(s),Double Sinks in Primary Bath,Linen Closet/Storage,Main Floor Full Bath,Quartz Counters,Remodeled,Upgraded,Walk-in shower",\n "AdminUpdateYN": "0",\n "ListingKey": "1116210842",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1116210842')" +"CurrentPrice": 1799999.0 +"provider_name": "CRMLS" +"RecordSignature": 1561539875 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:14164323" +"CountrySubdivision": "06059" +"OriginatingSystemListOfficeKey": "37648" +"OriginatingSystemCoListOfficeKey": "37648" +"OriginatingSystemListAgentMemberKey": "289922" +"OriginatingSystemCoListAgentMemberKey": "373749014" +"Media": array:29 [ …29] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4013 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1114405046" +"ListingId": "OC25114208" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T23:03:37Z" +"RFModificationTimestamp": "2025-06-15T00:28:12.166040+00:00" +"ListPrice": 2599000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 7455.0 +"LivingArea": 2646.0 +"BuildingAreaTotal": 0 +"City": "Costa Mesa" +"PostalCode": "92626" +"UnparsedAddress": "3119 Gibraltar Avenue, Costa Mesa, California 92626" +"Coordinates": array:2 [ …2] +"Latitude": 33.683989 +"Longitude": -117.926049 +"YearBuilt": 1957 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Sina Oveissi" +"ListOfficeName": "Pointe Real Estate Inc." +"ListAgentMlsId": "OCOVEISIN" +"ListOfficeMlsId": "OC12496" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Newly remodeled Mesa Verde home has been carefully curated for you by one of the construction stars of HGTV! This stunning remodel features 5 bedrooms, 4 bathrooms and has over 2,600 square feet of luxurious living space. This home features two primary bedrooms, both featuring en-suite bathrooms and plenty of closet space, which makes this home perfect for multi-generational living and hosting guests. The newly transformed kitchen includes all Thermador appliances, a kitchen island, quartz countertops, and tastefully designed cabinetry. Step outside into your own private oasis with a sparkling pool and spacious backyard with bbq and fire pit on a private 7,455 square foot lot, perfect for year-round entertainment. Additional highlights include a two-car garage, solar, dual zone A/C, newer sewer line, tankless water heater, brand new European white oak hardwood floors, dual pane windows, copper gutters, & security cameras. Located in the highly desired Mesa Verde community in Costa Mesa, which is conveniently located close to shopping, dining, parks, and top-rated schools, this is the rare opportunity that is not to be missed. Make sure to check out the stunning video." +"ActivationDate": "2025-05-23" +"Appliances": "Dishwasher,Gas Oven,Gas Range,Microwave,Refrigerator,Tankless Water Heater,Dryer,Washer" +"AttachedGarageYN": true +"AttributionContact": "949-624-2600" +"BackOnMarketDate": "2025-05-30" +"BathroomsFull": 4 +"CLIP": 1494160072 +"CoListAgentAOR": "Citrus Valley" +"CoListAgentDirectPhone": "714-519-5415" +"CoListAgentEmail": "dhopkins.pointere@gmail.com" +"CoListAgentFirstName": "Dakota" +"CoListAgentFullName": "Dakota Hopkins" +"CoListAgentKey": "17294288" +"CoListAgentKeyNumeric": "17294288" +"CoListAgentLastName": "Hopkins" +"CoListAgentMlsId": "CV44301" +"CoListAgentOfficePhone": "626-484-4046" +"CoListAgentStateLicense": "02091570" +"CoListOfficeAOR": "Citrus Valley" +"CoListOfficeKey": "3294237" +"CoListOfficeKeyNumeric": "3294237" +"CoListOfficeMlsId": "52541" +"CoListOfficeName": "POINTE REAL ESTATE INC." +"CoListOfficePhone": "626-484-4046" +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Street Lights,Sidewalks" +"Contingency": "Standard Contract Contingencies" +"ContractStatusChangeDate": "2025-05-22" +"Cooling": "Central Air,Dual,Zoned" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-05-31T02:29:34.801878+00:00" +"CumulativeDaysOnMarket": 22 +"DaysOnMarket": 22 +"DaysOnMarketReplication": 22 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Gisler turn onto Gilbraltar" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"Fencing": "Block, Wood" +"FireplaceFeatures": "None" +"Flooring": "Tile, Wood" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central,Forced Air,Zoned" +"HeatingYN": true +"HighSchoolDistrict": "Newport Mesa Unified" +"InteriorFeatures": "Beamed Ceilings,Balcony,Cathedral Ceiling(s),Quartz Counters,Recessed Lighting,Main Level Primary,Multiple Primary Suites,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"Levels": "One" +"ListAgentAOR": "Orange County" +"ListAgentEmail": "soveissi.pointere@gmail.com" +"ListAgentFirstName": "Sina" +"ListAgentKey": "17180676" +"ListAgentKeyNumeric": "17180676" +"ListAgentLastName": "Oveissi" +"ListAgentOfficePhone": "949-624-2600" +"ListAgentStateLicense": "02000356" +"ListOfficeAOR": "Orange County" +"ListOfficeEmail": "pointerealestate@gmail.com" +"ListOfficeKey": "3942319" +"ListOfficeKeyNumeric": "3942319" +"ListOfficePhone": "949-624-2600" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-22" +"ListingKeyNumeric": 1114405046 +"ListingService": "Full Service" +"ListingTerms": "Cash, Conventional" +"LivingAreaSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre,Back Yard,Corner Lot,Front Yard" +"LotSizeAcres": 0.1711 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7455.0 +"MLSAreaMajor": "C1 - Mesa Verde" +"MainLevelBathrooms": 2 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-05-30T16:42:13Z" +"MajorChangeType": "Back On Market" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OffMarketDate": "2025-05-30" +"OffMarketTimestamp": "2025-05-30T12:42:59Z" +"OnMarketDate": "2025-05-23" +"OnMarketTimestamp": "2025-05-30T16:42:13Z" +"OriginalEntryTimestamp": "2025-05-22T08:00:27Z" +"OriginalListPrice": 2599000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374453947" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "13915411" +"ParkingFeatures": "Door-Multi, Garage" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-05-22T15:39:40Z" +"PhotosCount": 67 +"PoolFeatures": "Heated,In Ground,Private" +"PoolPrivateYN": true +"Possession": "Close Of Escrow" +"PostalCodePlus4": "2309" +"PropertyCondition": "Updated/Remodeled" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Kitchen,Living Room,Primary Bedroom,Other" +"Sewer": "Public Sewer" +"ShowingContactName": "Sina" +"ShowingContactType": "Agent" +"SignOnPropertyYN": true +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1114405046" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StartShowingDate": "2025-05-23" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-30T16:42:13Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Gibraltar" +"StreetNumber": "3119" +"StreetNumberNumeric": "3119" +"StreetSuffix": "Avenue" +"StructureType": "House" +"SubdivisionName": "Summerland (MISS)" +"TaxLot": "113" +"UniversalPropertyId": "US-06059-N-13915411-R-N" +"Utilities": "Electricity Connected" +"View": "None" +"VirtualTourURLBranded": "https://www.wellcomemat.com/video/5a1b908759701m2m2/CM/CA/92626/Gibraltar/OC25060128/" +"VirtualTourURLUnbranded": "https://www.wellcomemat.com/mls/5a1b908759701m2m2" +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "Kitchen,Living Room,Main Floor Primary Bedroom,Two Primaries,Walk-In Closet",\n "RoomKitchenFeatures": "Kitchen Island,Kitchen Open to Family Room,Quartz Counters,Remodeled Kitchen",\n "RoomBathroomFeatures": "Main Floor Full Bath,Quartz Counters,Remodeled",\n "AdminUpdateYN": "0",\n "ListingKey": "1114405046",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1114405046')" +"CurrentPrice": 2599000.0 +"provider_name": "CRMLS" +"RecordSignature": -1210835145 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:13915411" +"CountrySubdivision": "06059" +"PreviousStandardStatus": "Hold" +"OriginatingSystemListOfficeKey": "364775689" +"OriginatingSystemCoListOfficeKey": "364236814" +"OriginatingSystemListAgentMemberKey": "13477569" +"OriginatingSystemCoListAgentMemberKey": "364461247" +"Media": array:67 [ …67] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4014 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1113100010" +"ListingId": "PW25102384" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T22:57:44Z" +"RFModificationTimestamp": "2025-06-15T00:30:38.807062+00:00" +"ListPrice": 1975000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 6100.0 +"LivingArea": 2500.0 +"BuildingAreaTotal": 0 +"City": "Costa Mesa" +"PostalCode": "92626" +"UnparsedAddress": "3108 Sumatra Place, Costa Mesa, California 92626" +"Coordinates": array:2 [ …2] +"Latitude": 33.68347 +"Longitude": -117.927901 +"YearBuilt": 1957 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Kip Hancock" +"ListOfficeName": "Torelli Realty" +"ListAgentMlsId": "PWHANCKIP" +"ListOfficeMlsId": "PB14453" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "This lovely home sits on a quiet interior street located in the Island Streets of Mesa Verde! The spacious open living room invites you in with it's natural lighting leading to a formal dining room that sits off of the recently remodeled kitchen. The main floor has a over sized family room with a cozy brick fireplace boasting the perfect gathering place for friends and family. The back yard is surrounded by mature blossoming flowers and a well manicured lawn. The recently remodeled master suite is large and comfortable. With vaulted ceilings, sitting nook off the bay window, a HUGE custom walk in closet and over sized walk in shower with glass enclosure, this is what everyone wants. Conveniently located laundry room off the upstairs hallway makes laundry a breeze. Each additional bedroom is ample sized and has some nice added touches including optimal closet storage and hanger space. The 2 car garage could be deemed a 3 car garage with it's 630 sqft. It has storage space throughout and easily fits two full size SUV's and has direct access to both the home and the backyard. There is an additional enclosed shed to hold your lawn equipment or all of your beach gear. Welcome home!" +"Appliances": "Dishwasher,Disposal,Gas Oven,Refrigerator" +"AttachedGarageYN": true +"AttributionContact": "714-227-5932" +"BathroomsFull": 3 +"CLIP": 8510228280 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Storm Drain(s),Street Lights,Sidewalks" +"ConstructionMaterials": "Drywall,Stucco,Copper Plumbing" +"Contingency": "to find replacement property" +"ContractStatusChangeDate": "2025-05-11" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-05-12T02:11:39.354486+00:00" +"CumulativeDaysOnMarket": 34 +"DaysOnMarket": 34 +"DaysOnMarketReplication": 34 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Rt Labrador left Orcas Rt Sumatra" +"DoorFeatures": "Sliding Doors" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"Exclusions": "Washer/dryer & refridgerator" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"Flooring": "Carpet, Wood" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchool": "Estancia" +"HighSchoolDistrict": "Newport Mesa Unified" +"InteriorFeatures": "Beamed Ceilings,Balcony,Ceiling Fan(s),Crown Molding,Cathedral Ceiling(s),Separate/Formal Dining Room,Open Floorplan,Pantry,Paneling/Wainscoting,Quartz Counters,Recessed Lighting,Storage,All Bedrooms Up,Galley Kitchen,Primary Suite,Walk-In Closet(s)" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Laundry Room" +"Levels": "Two" +"ListAgentAOR": "Pacific West" +"ListAgentDirectPhone": "714-227-5932" +"ListAgentEmail": "kiphancock1@gmail.com" +"ListAgentFirstName": "Kip" +"ListAgentKey": "17283062" +"ListAgentKeyNumeric": "17283062" +"ListAgentLastName": "Hancock" +"ListAgentOfficePhone": "714-540-7355" +"ListAgentOfficePhoneExt": "0" +"ListAgentStateLicense": "01336886" +"ListAgentVoiceMail": "714-227-5932" +"ListAgentVoiceMailExt": "0" +"ListOfficeAOR": "Pacific West" +"ListOfficeEmail": "nick@torellirealty.com" +"ListOfficeFax": "714-540-4804" +"ListOfficeKey": "3281131" +"ListOfficeKeyNumeric": "3281131" +"ListOfficePhone": "714-540-7355" +"ListOfficePhoneExt": "0" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-11" +"ListingKeyNumeric": 1113100010 +"ListingService": "Full Service" +"ListingTerms": "Submit" +"LivingAreaSource": "Assessor" +"LotFeatures": "Back Yard,Front Yard,Landscaped" +"LotSizeAcres": 0.14 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 6100.0 +"MLSAreaMajor": "C1 - Mesa Verde" +"MainLevelBathrooms": 1 +"MajorChangeTimestamp": "2025-05-29T14:21:50Z" +"MajorChangeType": "Price Change" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-05-11" +"OnMarketTimestamp": "2025-05-11T18:43:18Z" +"OpenParkingSpaces": "4.0" +"OriginalEntryTimestamp": "2025-05-11T18:43:18Z" +"OriginalListPrice": 1999000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374391111" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "13915313" +"ParkingFeatures": "Door-Multi,Driveway,Garage,Garage Door Opener,RV Potential,RV Access/Parking" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-05-12T02:07:38Z" +"PhotosCount": 27 +"PoolFeatures": "None" +"PostalCodePlus4": "2337" +"PreviousListPrice": 1999000.0 +"PriceChangeTimestamp": "2025-05-29T14:21:50Z" +"PropertyCondition": "Turnkey" +"PropertySubTypeAdditional": "Single Family Residence" +"RoadFrontageType": "City Street" +"RoadSurfaceType": "Paved" +"Roof": "Composition" +"RoomType": "Bedroom,Family Room,Kitchen,Laundry,Living Room,Primary Bedroom,Other,Dining Room" +"Sewer": "Public Sewer" +"ShowingContactName": "Kip W Hancock" +"ShowingContactPhone": "714-227-5932" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1113100010" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-11T18:43:18Z" +"Stories": "2" +"StoriesTotal": "1" +"StreetName": "Sumatra" +"StreetNumber": "3108" +"StreetNumberNumeric": "3108" +"StreetSuffix": "Place" +"StructureType": "House" +"SubdivisionName": "Summerland (MISS)" +"TaxLot": "77" +"UniversalPropertyId": "US-06059-N-13915313-R-N" +"Utilities": "Cable Available,Electricity Connected,Natural Gas Connected,Phone Available,Sewer Connected,Water Connected" +"View": "None" +"WaterSource": "Public" +"WindowFeatures": "Double Pane Windows" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "All Bedrooms Up,Family Room,Galley Kitchen,Kitchen,Laundry,Living Room,Primary Suite,Walk-In Closet",\n "EatingArea": "Dining Room",\n "RoomKitchenFeatures": "Quartz Counters,Remodeled Kitchen",\n "RoomBathroomFeatures": "Remodeled",\n "AdminUpdateYN": "0",\n "ListingKey": "1113100010",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1113100010')" +"CurrentPrice": 1975000.0 +"provider_name": "CRMLS" +"RecordSignature": -1920112994 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:13915313" +"CountrySubdivision": "06059" +"OriginatingSystemListOfficeKey": "44712" +"OriginatingSystemListAgentMemberKey": "542396" +"Media": array:27 [ …27] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4015 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112681822" +"ListingId": "OC25098136" +"PropertyType": "Residential Income" +"PropertySubType": "Triplex" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T22:57:44Z" +"RFModificationTimestamp": "2025-06-15T00:32:40.491976+00:00" +"ListPrice": 1769000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 7841.0 +"LivingArea": 0 +"BuildingAreaTotal": 3326.0 +"City": "Costa Mesa" +"PostalCode": "92626" +"UnparsedAddress": "117 Clearbrook Lane, Costa Mesa, California 92626" +"Coordinates": array:2 [ …2] +"Latitude": 33.662485 +"Longitude": -117.905705 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Melissa Wiesen" +"ListOfficeName": "eXp Realty of California Inc" +"ListAgentMlsId": "SWIESMEL" +"ListOfficeMlsId": "OC03224" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "This triplex offers an incredible opportunity with loyal tenants and good rental income in one of the most sought-after areas of Costa Mesa. Conveniently located directly across from the Fairgrounds and Vanguard University. With easy access to major attractions, shopping, dining, and public transportation, this property is ideally situated for convenience and comfort. The triplex consists of two 1-bedroom units and one 2-bedroom, 1-bath unit, each featuring private laundry facilities, private yards, and a garage. The 2-bedroom unit has been nicely upgraded with modern finishes, making it a standout space. Each unit offers ample living space, providing tenants with the perfect combination of privacy and convenience. With its prime location and desirable features, this triplex presents an excellent investment opportunity or a great multi-generational living situation." +"AttributionContact": "949-887-6644" +"BuildingAreaUnits": "Square Feet" +"CLIP": 3725832626 +"CommonInterest": "None" +"CommonWalls": "2+ Common Walls" +"CommunityFeatures": "Biking, Curbs, Gutter(s), Urban" +"ContractStatusChangeDate": "2025-05-05" +"Cooling": "None" +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-05-06T01:46:27.634102+00:00" +"CumulativeDaysOnMarket": 40 +"DaysOnMarket": 40 +"DaysOnMarketReplication": 40 +"DaysOnMarketReplicationDate": "2025-06-14" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Fair and Vanguard" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"FireplaceFeatures": "None" +"GarageSpaces": "4.0" +"GarageYN": true +"GrossIncome": 90483.0 +"GrossScheduledIncome": 90483.0 +"InsuranceExpense": 2000.0 +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Outside" +"Levels": "Two" +"ListAgentAOR": "Orange County" +"ListAgentDirectPhone": "949-887-6644" +"ListAgentEmail": "realtormissy3@yahoo.com" +"ListAgentFax": "949-388-9853" +"ListAgentFirstName": "Melissa" +"ListAgentKey": "17249820" +"ListAgentKeyNumeric": "17249820" +"ListAgentLastName": "Wiesen" +"ListAgentOfficePhone": "888-584-9427" +"ListAgentStateLicense": "01745112" +"ListAgentVoiceMailExt": "0" +"ListOfficeAOR": "Orange County" +"ListOfficeEmail": "centralca@exprealty.com" +"ListOfficeKey": "3287510" +"ListOfficeKeyNumeric": "3287510" +"ListOfficePhone": "888-584-9427" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-05" +"ListingKeyNumeric": 1112681822 +"ListingService": "Full Service" +"ListingTerms": "1031 Exchange" +"LotFeatures": "0-1 Unit/Acre" +"LotSizeAcres": 0.18 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7841.0 +"MLSAreaMajor": "C4 - Central Costa Mesa" +"MajorChangeTimestamp": "2025-06-14T15:34:03Z" +"MajorChangeType": "Price Change" +"MlsStatus": "Active" +"NetOperatingIncome": 71083.0 +"NumberOfBuildings": 1 +"NumberOfSeparateElectricMeters": 3 +"NumberOfSeparateGasMeters": 3 +"NumberOfSeparateWaterMeters": 1 +"NumberOfUnitsTotal": "3" +"OnMarketDate": "2025-05-05" +"OnMarketTimestamp": "2025-05-05T18:20:02Z" +"OperatingExpense": "19400.0" +"OriginalEntryTimestamp": "2025-05-05T18:20:02Z" +"OriginalListPrice": 1825000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374359104" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "41914119" +"ParkingFeatures": "Garage" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-05-06T04:02:41Z" +"PhotosCount": 3 +"PoolFeatures": "None" +"PostalCodePlus4": "8512" +"PreviousListPrice": 1799000.0 +"PriceChangeTimestamp": "2025-06-14T15:34:03Z" +"PropertyAttachedYN": true +"PropertySubTypeAdditional": "Triplex" +"Sewer": "Public Sewer" +"ShowingContactType": "See Remarks" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112681822" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-05T18:20:02Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Clearbrook" +"StreetNumber": "117" +"StreetNumberNumeric": "117" +"StreetSuffix": "Lane" +"SubdivisionName": "other" +"TaxLot": "14" +"TenantPays": "Cable TV,Electricity,Gas" +"TrashExpense": 600.0 +"UniversalPropertyId": "US-06059-N-41914119-R-N" +"WaterSewerExpense": 1800.0 +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "AdminUpdateYN": "0",\n "ListingKey": "1112681822",\n "DPResourceYN": "1"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"ThirdPartyIntegrationType": "Down Payment Resource" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112681822')" +"CurrentPrice": 1769000.0 +"provider_name": "CRMLS" +"RecordSignature": -1371673848 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:41914119" +"CountrySubdivision": "06059" +"OriginatingSystemListOfficeKey": "130118" +"OriginatingSystemListAgentMemberKey": "297182" +"Media": array:3 [ …3] } ] +success: true +page_size: 10 +page_count: 195 +count: 1950 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5445 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5444 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1115044718" +"ListingId": "OC25127680" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:06:47.363769+00:00" +"ListPrice": 5700000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 13503.6 +"LivingArea": 2047.0 +"BuildingAreaTotal": 0 +"City": "Corona Del Mar" +"PostalCode": "92625" +"UnparsedAddress": "4621 Hampden Rd, Corona Del Mar, California 92625" +"Coordinates": array:2 [ …2] +"Latitude": 33.589326 +"Longitude": -117.859593 +"YearBuilt": 1959 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lynn Paris" +"ListOfficeName": "Pinnacle Real Estate Group" +"ListAgentMlsId": "OCPARILYN" +"ListOfficeMlsId": "OC06746" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": """ Elegant Coastal Living | Beautifully Remodeled Home in the Coveted Cameo Shores Community! As a resident of Cameo Shores, you enjoy exclusive access to the stunning private beaches, unlocked by your key to two separate entrances. These beaches are not only breathtaking, featuring incredible rock formations, but also offer a sense of privacy that's hard to find elsewhere. Additionally, residents can take advantage of scenic beach trails that meander through the picturesque Pelican Hill Golf Course, providing a perfect blend of nature and recreation. The unique pathways in the community connect you seamlessly to Third Beach in Corona del Mar and Crystal Cove State Beach, allowing for easy enjoyment of walking and surfing. Ultimately, you also have the opportunity to explore the beautiful Crystal Cove State Park, as well as the charming Village of Corona Del Mar, thereby enhancing your coastal living experience.\r\r\n This stunning property is situated on a rare 0.31-acre lot with great appreciation potential, Nestled in a private corner, this home features a tranquil backyard, front yard, and side yard that ensure ample natural light and privacy. Floor-to-ceiling windows beautifully integrate the natural landscape of the yard with the open-concept layout. The spacious design includes a large kitchen, a generous master suite, two additional bedrooms, a home office, and an outdoor dining terrace, all thoughtfully arranged. The garage and front yard provide convenient parking options. The entire home has undergone extensive renovation and upgrading.\r\r\n .A significant highlight is the rare 0.31-acre lot, which offers the potential for an ADU expansion or the construction of a new luxury home up to 8,000 square feet, complete with architect-designed plans included. This property presents tremendous potential for appreciation.\r\r\n Community Amenities: The private park and playground in Cameo Shores provide a safe space for families, allowing children and pets to play freely.\r\r\n Excellent School District: Rated 10/10, offering outstanding educational resources.Low Property HOA: Only $1,050 per year. For more details please don't hesitate to contact Lynn Paris at 949-351-1343. """ +"AssociationAmenities": "Dog Park,Golf Course,Jogging Path,Management,Barbecue,Picnic Area,Playground,Guard,Security,Trail(s)" +"AssociationFee": "1050.0" +"AssociationFeeFrequency": "Semi-Annually" +"AssociationName": "Powerstone Property Management" +"AssociationPhone": "9493724022" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "949-351-1343" +"BathroomsFull": 3 +"CLIP": 6289835863 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Dog Park" +"Contingency": "N" +"ContractStatusChangeDate": "2024-06-01" +"Cooling": "Central Air,Electric" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-06-07T06:26:21.386886+00:00" +"CumulativeDaysOnMarket": 8 +"DaysOnMarket": 8 +"DaysOnMarketReplication": 8 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "N/A" +"DocumentsChangeTimestamp": "2025-06-08T09:24:52Z" +"DocumentsCount": 1 +"ElementarySchool": "Harbor View" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "1" +"FireplaceFeatures": "Family Room,Gas" +"FireplaceYN": true +"GarageSpaces": "2.0" +"GarageYN": true +"HighSchool": "Newport Harbor" +"HighSchoolDistrict": "Newport Mesa Unified" +"InteriorFeatures": "All Bedrooms Down" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Washer Hookup,Electric Dryer Hookup" +"Levels": "One" +"ListAgentAOR": "Orange County" +"ListAgentEmail": "lynnlinparis@gmail.com" +"ListAgentFirstName": "Lynn" +"ListAgentKey": "21318104" +"ListAgentKeyNumeric": "21318104" +"ListAgentLastName": "Paris" +"ListAgentOfficePhone": "626-888-9808" +"ListAgentStateLicense": "02193706" +"ListOfficeAOR": "Orange County" +"ListOfficeEmail": "usnationalrealty@gmail.com" +"ListOfficeFax": "626-986-5345" +"ListOfficeKey": "3275512" +"ListOfficeKeyNumeric": "3275512" +"ListOfficePhone": "626-888-9808" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2024-06-01" +"ListingKeyNumeric": 1115044718 +"ListingService": "Full Service" +"ListingTerms": "Cash,Cash to New Loan,Conventional,1031 Exchange" +"LivingAreaSource": "Public Records" +"LotFeatures": "Sprinklers In Front,Sprinklers On Side,Value In Land" +"LotSizeAcres": 0.31 +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 13503.6 +"MLSAreaMajor": "699 - Not Defined" +"MainLevelBathrooms": 3 +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-06-06T23:02:41Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Corona Del Mar" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "3" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-06" +"OnMarketTimestamp": "2025-06-06T23:02:41Z" +"OriginalEntryTimestamp": "2025-06-06T23:02:41Z" +"OriginalListPrice": 5700000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374548978" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "47505411" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-08T16:33:40Z" +"PhotosCount": 42 +"PoolFeatures": "None" +"PropertySubTypeAdditional": "Single Family Residence" +"RoomType": "Bedroom,Family Room,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Office" +"Sewer": "Public Sewer" +"ShowingContactName": "Lynn Paris" +"ShowingContactPhone": "9493511343" +"ShowingContactType": "Agent" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1115044718" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-06T23:02:41Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Hampden Rd" +"StreetNumber": "4621" +"StreetNumberNumeric": "4621" +"StructureType": "House" +"TaxLot": "n" +"UniversalPropertyId": "US-06059-N-47505411-R-N" +"View": "Park/Greenbelt,Golf Course,Ocean,Trees/Woods" +"ViewYN": true +"VirtualTourURLBranded": "https://www.wellcomemat.com/video/5979bb66942c1m6fu/CDM/CA/92625/Hampden-Rd/OC25127680/" +"VirtualTourURLUnbranded": "https://www.wellcomemat.com/mls/5979bb66942c1m6fu" +"WaterSource": "Public" +"YearBuiltSource": "Public Records" +"CustomFields": """ {\n "RoomType": "All Bedrooms Down,Family Room,Kitchen,Laundry,Living Room,Primary Bathroom,Primary Bedroom,Office",\n "AdminUpdateYN": "0",\n "ListingKey": "1115044718",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1115044718')" +"CurrentPrice": 5700000.0 +"provider_name": "CRMLS" +"RecordSignature": 2080925851 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:47505411" +"CountrySubdivision": "06059" +"OriginatingSystemListOfficeKey": "143572682" +"OriginatingSystemListAgentMemberKey": "369525581" +"Media": array:42 [ …42] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5635 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112308116" +"ListingId": "25531679" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:07:19.378602+00:00" +"ListPrice": 414500.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 5320.0 +"LivingArea": 726.0 +"BuildingAreaTotal": 726.0 +"City": "San Bernardino" +"PostalCode": "92411" +"UnparsedAddress": "1256 W 6th Street, San Bernardino, California 92411" +"Coordinates": array:2 [ …2] +"Latitude": 34.110461 +"Longitude": -117.312781 +"YearBuilt": 1910 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Eran Fattal" +"ListOfficeName": "Dynasty Real Estate" +"ListAgentMlsId": "CLW-C103971" +"ListOfficeMlsId": "CLW-X78890" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "REMODELED FHA APPROVED HOME: 3 BEDS PLUS 1.5 BATH. (PUBLIC RECORDS SHOW 2 PLUS 1) NEW DUAL PANE WINDOWS. REPLACED CENTRAL AIR AND HEAT. NEW CUSTOM PORCELAIN TILE FLOORING IN KITCHEN, LIVING ROOM, BATHROOMS, AND LAUNDRY ROOM. NEW GRAY RUSTIC STYLE LAMINATE FLOORING IN BEDROOMS. THE KITCHEN IS BRAND NEW. NEW CUSTOM KITCHEN CABINETS, NEW QUARTZ STONE COUNTERS, NEW GARBAGE DISPOSAL, NEW PULL-OUT FAUCET. NEW BATHTUB, NEW TILED UP SHOWERS WALLS WITH ELEGANT MOSAIC DESIGN, NEW VANITIES. NEW TOILETS. ALL NEW PLUMBING FIXTURES. NEW LIGHT FIXTURES. NEW PAINT INSIDE AND OUT. NEW GARAGE DOOR. FHA/VA/DOWN PAYMENT ASSISTANCE/OK" +"Appliances": "Disposal" +"ArchitecturalStyle": "See Remarks" +"BathroomsFull": 1 +"BuyerFinancing": "Conventional, FHA, VA" +"CLIP": 8804738686 +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-04-29" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "San Bernardino" +"CreationDate": "2025-04-29T19:32:38.644803+00:00" +"DaysOnMarket": 46 +"DaysOnMarketReplication": 46 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "PLEASE REFER TO GOOGLE MAPS" +"FireplaceFeatures": "None" +"Flooring": "Laminate" +"Furnished": "Unfurnished" +"Heating": "Central" +"HeatingYN": true +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Inside" +"Levels": "One" +"ListAgentAOR": "Out of Area Board" +"ListAgentDirectPhone": "747-343-1266" +"ListAgentEmail": "eranfattal@icloud.com" +"ListAgentFax": "909-373-2515" +"ListAgentFirstName": "Eran" +"ListAgentKey": "17056852" +"ListAgentKeyNumeric": "17056852" +"ListAgentLastName": "Fattal" +"ListAgentOfficePhone": "909-373-2505" +"ListAgentStateLicense": "01304180" +"ListOfficeAOR": "Out of Area Board" +"ListOfficeFax": "909-373-2515" +"ListOfficeKey": "3237841" +"ListOfficeKeyNumeric": "3237841" +"ListOfficePhone": "909-373-2505" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-04-29" +"ListingKeyNumeric": 1112308116 +"ListingService": "Entry Only" +"LotSizeAcres": 0.1221 +"LotSizeDimensions": "38x140" +"LotSizeSquareFeet": 5320.0 +"MLSAreaMajor": "274 - San Bernardino" +"MajorChangeType": "Price Change" +"MlsStatus": "Active" +"OnMarketDate": "2025-04-29" +"OnMarketTimestamp": "2025-04-29T04:31:51Z" +"OriginalEntryTimestamp": "2025-04-29T11:17:09Z" +"OriginalListPrice": 425000.0 +"OriginatingSystemID": "CL" +"OriginatingSystemKey": "374319567" +"OriginatingSystemSubName": "CRMLS_CL" +"ParcelNumber": "0138052070000" +"ParkingFeatures": "Door-Single, Garage" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-04-29T20:25:39Z" +"PhotosCount": 8 +"PoolFeatures": "None" +"PostalCodePlus4": "2705" +"PreviousListPrice": 425000.0 +"PriceChangeTimestamp": "2025-06-14T16:51:35Z" +"PropertySubTypeAdditional": "Single Family Residence" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112308116" +"SpaFeatures": "None" +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-04-29T00:00:00Z" +"Stories": "1" +"StoriesTotal": "1" +"StreetDirPrefix": "W" +"StreetName": "6th" +"StreetNumber": "1256" +"StreetNumberNumeric": "1256" +"StreetSuffix": "Street" +"UniversalPropertyId": "US-06071-N-0138052070000-R-N" +"View": "None" +"CustomFields": """ {\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1112308116"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112308116')" +"CurrentPrice": 414500.0 +"provider_name": "CRMLS" +"RecordSignature": -791365164 +"UniversalParcelId": "urn:reso:upi:2.0:US:06071:0138052070000" +"CountrySubdivision": "06071" +"OriginatingSystemListOfficeKey": "113814" +"OriginatingSystemListAgentMemberKey": "442704" +"Media": array:8 [ …8] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5633 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1112991539" +"ListingId": "ML82006135" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:07:32.027614+00:00" +"ListPrice": 499000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 4.25 +"LivingArea": 950.0 +"BuildingAreaTotal": 0 +"City": "Fremont" +"PostalCode": "94536" +"UnparsedAddress": "38500 Paseo Padre Pkwy 102, Fremont, California 94536" +"Coordinates": array:2 [ …2] +"Latitude": 37.55788739 +"Longitude": -121.98683642 +"YearBuilt": 1970 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Nisha Singh" +"ListOfficeName": "eXp Realty of California Inc" +"ListAgentMlsId": "ML5101215" +"ListOfficeMlsId": "ML5009355" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Discover modern living in heart of Fremont in the highly desirable Parkmont neighborhood! This spacious condo has an ideal floor plan that includes a large living room, sizable bedrooms, kitchen and a formal dining area. Parkmont Gardens community includes ideal amenities including a lush greenbelt and a swimming pool! This home is in an excellent commuter location, walking distance from BART and nearby Centerville Train Station, 880 freeway, 680 freeway and Niles Canyon. Around the corner from multiple shopping centers, Whole Foods, Centerville Community Park, Alameda Creek Trail, great schools and beloved local eateries! This home is a must see!" +"Appliances": "Gas Cooktop,Refrigerator" +"AssociationAmenities": "Trash" +"AssociationFee": "550.0" +"AssociationFeeFrequency": "Monthly" +"AssociationName": "Parkmont Gardens HOA" +"AssociationPhone": "925-495-4545" +"AssociationYN": true +"BathroomsFull": 1 +"CLIP": 8478246755 +"CommonInterest": "Condominium" +"ContractStatusChangeDate": "2025-05-08" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "Alameda" +"CreationDate": "2025-05-09T04:14:15.565194+00:00" +"DaysOnMarket": 37 +"DaysOnMarketReplication": 37 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": " Cross Street: paseo padre" +"Flooring": "Carpet" +"FoundationDetails": "Slab" +"GarageSpaces": "1.0" +"GarageYN": true +"Heating": "Wall Furnace" +"HeatingYN": true +"HighSchoolDistrict": "Alameda City Unified" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentEmail": "nishasingh@gmail.com" +"ListAgentFirstName": "Nisha" +"ListAgentKey": "24251205" +"ListAgentKeyNumeric": "24251205" +"ListAgentLastName": "Singh" +"ListAgentOfficePhone": "(888) 584-942..." +"ListAgentStateLicense": "01937867" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "925-262-1171" +"ListOfficeKey": "4763658" +"ListOfficeKeyNumeric": "4763658" +"ListOfficePhone": "(888) 584-942..." +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-08" +"ListingKeyNumeric": 1112991539 +"LivingAreaSource": "Other" +"LotSizeAcres": 0.0001 +"LotSizeSource": "Other" +"LotSizeSquareFeet": 4.25 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Vacant" +"OnMarketDate": "2025-05-08" +"OnMarketTimestamp": "2025-05-08T13:48:49Z" +"OriginalEntryTimestamp": "2025-05-08T13:21:18Z" +"OriginalListPrice": 499000.0 +"OriginatingSystemID": "MLSL" +"OriginatingSystemKey": "374380809" +"OriginatingSystemSubName": "CRMLS_MLSL" +"ParcelNumber": "501153439" +"ParkingFeatures": "Covered,Off Street" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-06-13T18:36:45Z" +"PhotosCount": 7 +"PoolFeatures": "In Ground" +"PropertySubTypeAdditional": "Condominium" +"Roof": "Other" +"Sewer": "Other" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1112991539" +"SpaFeatures": "In Ground" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-05-08T13:21:18Z" +"StreetName": "Paseo Padre Pkwy" +"StreetNumber": "38500" +"StreetNumberNumeric": "38500" +"UnitNumber": "102" +"UniversalPropertyId": "US-06001-N-501153439-R-N" +"WaterSource": "Public" +"YearBuiltSource": "Other" +"Zoning": "Residential" +"CustomFields": """ {\n "EatingArea": "In Living Room",\n "AdminUpdateYN": "0",\n "ListingKey": "1112991539"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1112991539')" +"CurrentPrice": 499000.0 +"provider_name": "CRMLS" +"RecordSignature": -1685891191 +"UniversalParcelId": "urn:reso:upi:2.0:US:06001:501153439" +"CountrySubdivision": "06001" +"OriginatingSystemListOfficeKey": "368558053" +"OriginatingSystemListAgentMemberKey": "372906814" +"Media": array:7 [ …7] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5632 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1117318108" +"ListingId": "PW25130551" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:07:31.621904+00:00" +"ListPrice": 1295000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 7800.0 +"LivingArea": 1463.0 +"BuildingAreaTotal": 0 +"City": "Mission Viejo" +"PostalCode": "92691" +"UnparsedAddress": "23266 Via Ronda, Mission Viejo, California 92691" +"Coordinates": array:2 [ …2] +"Latitude": 33.625063 +"Longitude": -117.655413 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Rachel Baroth" +"ListOfficeName": "Berkshire Hathaway HomeServices California Properties" +"ListAgentMlsId": "PWBARRAC" +"ListOfficeMlsId": "PB1364" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "Welcome to 23266 Via Ronda in sought after Barcelona neighborhood offering 4 bedrooms, 3 baths, a spacious entertainers backyard featuring a custom heated pool and spa, a fully insulated patio cover complete with lighting, ceiling fans and custom curtain brackets for additional shade & comfort also boast beautiful easy care tropical fauna, mature lemon and orange trees, and a versatile large playhouse/ office/ hobby room wired with electric, lighting & internet. The perfect setting for summer BBQ’s, family birthdays, holidays or romantic evening dinners. The main level open floor plan has fireplace in cathedral ceiling living room, formal dining room with bright, natural light flowing thru kitchen window box and back door facing lush back yard patio and pool. Finishing the downstairs is a large bedroom with French doors opening to backyard, currently being used as entertainment room and a full bathroom. Retreat to the upstairs primary bedroom full en suite bath with jetted tub, walk in closet completed with vanity, custom shelving and drawers. Another full bath and 2 bedrooms, one loft style that could double as home office and LVP flooring throughout complete the upstairs. Energy-efficient solar panels provide cost-saving benefits, making this home as practical as it is beautiful. Completing this home is Central HVAC system, large 2 car attached garage with washer and dryer hookups, beautiful artificial turf for low maintenance front yard, And Full Access to Lake Mission Viejo Membership and all it has to offer. Talk about location, Award winning Capistrano schools, nearby Aurora Park with fields, playground, volleyball & basketball court, beautiful wooded area for the evening strolls, fine restaurants, shopping and golf course all nearby!" +"Appliances": "Dishwasher,Gas Oven,Refrigerator" +"ArchitecturalStyle": "Traditional" +"AssociationAmenities": "Controlled Access,Picnic Area,Playground" +"AssociationFee": "179.0" +"AssociationFeeFrequency": "Semi-Annually" +"AssociationName": "Mission Viejo Lake Membership" +"AssociationPhone": "949-770-1313" +"AssociationYN": true +"AttachedGarageYN": true +"AttributionContact": "rachel@rachelbaroth.com" +"BathroomsFull": 3 +"CLIP": 8991206809 +"CommonInterest": "None" +"CommonWalls": "No Common Walls" +"CommunityFeatures": "Gutter(s)" +"ContractStatusChangeDate": "2025-06-10" +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Orange" +"CreationDate": "2025-06-13T03:02:02.144261+00:00" +"CumulativeDaysOnMarket": 2 +"DaysOnMarket": 2 +"DaysOnMarketReplication": 2 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Exit 5 freeway at Alicia Parkway, follow Alicia Parkway to Right on Via Aura to Right on Via Ronda" +"ElevationUnits": "Feet" +"EntryLevel": 1 +"EntryLocation": "Front" +"Fencing": "Block" +"FireplaceFeatures": "Living Room" +"FireplaceYN": true +"Flooring": "Tile, Vinyl" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchool": "Capistrano Valley" +"HighSchoolDistrict": "Capistrano Unified" +"Inclusions": "Refrigerator" +"InteriorFeatures": "Cathedral Ceiling(s),Separate/Formal Dining Room,Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "In Garage" +"Levels": "Two" +"ListAgentAOR": "Pacific West" +"ListAgentEmail": "rachel@rachelbaroth.com" +"ListAgentFirstName": "Rachel" +"ListAgentKey": "17072220" +"ListAgentKeyNumeric": "17072220" +"ListAgentLastName": "Baroth" +"ListAgentOfficePhone": "562-989-4608" +"ListAgentOfficePhoneExt": "0" +"ListAgentStateLicense": "01396461" +"ListOfficeAOR": "Pacific West" +"ListOfficeFax": "562-989-4803" +"ListOfficeKey": "3284761" +"ListOfficeKeyNumeric": "3284761" +"ListOfficePhone": "562-989-4608" +"ListOfficePhoneExt": "0" +"ListingAgreement": "Open" +"ListingContractDate": "2025-06-10" +"ListingKeyNumeric": 1117318108 +"ListingService": "Entry Only" +"ListingTerms": "Cash, Conventional, FHA" +"LivingAreaSource": "Assessor" +"LotDimensionsSource": "Assessor" +"LotFeatures": "0-1 Unit/Acre" +"LotSizeAcres": 0.1791 +"LotSizeDimensions": "130 x 60" +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 7800.0 +"MLSAreaMajor": "699 - Not Defined" +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-06-12T16:53:41Z" +"MajorChangeType": "New Listing" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OccupantType": "Owner" +"OnMarketDate": "2025-06-12" +"OnMarketTimestamp": "2025-06-12T16:53:41Z" +"OriginalEntryTimestamp": "2025-06-12T16:53:41Z" +"OriginalListPrice": 1295000.0 +"OriginatingSystemID": "CRM" +"OriginatingSystemKey": "374576329" +"OriginatingSystemSubName": "CRMLS_CRM" +"ParcelNumber": "80826104" +"ParkingFeatures": "Garage" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-15T06:51:40Z" +"PhotosCount": 19 +"PoolFeatures": "Gas Heat,Heated,In Ground,Private" +"PoolPrivateYN": true +"Possession": "Close Plus 3 Days" +"PostalCodePlus4": "2229" +"PropertySubTypeAdditional": "Single Family Residence" +"Roof": "Composition, Shingle" +"RoomType": "Bedroom,Dining Room" +"Sewer": "Public Sewer" +"ShowingContactName": "Anthony" +"ShowingContactPhone": "949-334-7305" +"ShowingContactType": "Owner" +"SourceSystemID": "TRESTLE" +"SourceSystemKey": "1117318108" +"SpaFeatures": "Heated,In Ground,Private" +"SpaYN": true +"SpecialListingConditions": "Standard" +"StateOrProvince": "CA" +"StatusChangeTimestamp": "2025-06-12T16:53:41Z" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Via Ronda" +"StreetNumber": "23266" +"StreetNumberNumeric": "23266" +"StructureType": "House" +"TaxLot": "38" +"UniversalPropertyId": "US-06059-N-80826104-R-N" +"View": "Mountain(s), Peek-A-Boo" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltSource": "Assessor" +"CustomFields": """ {\n "RoomType": "Main Floor Bedroom",\n "EatingArea": "Dining Room",\n "AdminUpdateYN": "0",\n "SellerConsiderConcessionYN": "1",\n "ListingKey": "1117318108",\n "DPResourceYN": "0"\n } """ +"HumanModifiedYN": false +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('1117318108')" +"CurrentPrice": 1295000.0 +"provider_name": "CRMLS" +"RecordSignature": -1772171666 +"UniversalParcelId": "urn:reso:upi:2.0:US:06059:80826104" +"CountrySubdivision": "06059" +"OriginatingSystemListOfficeKey": "43354" +"OriginatingSystemListAgentMemberKey": "9227702" +"Media": array:19 [ …19] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5656 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1113888520" +"ListingId": "ML82006272" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-15T07:02:49Z" +"RFModificationTimestamp": "2025-06-15T07:06:54.002631+00:00" +"ListPrice": 2725000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 8370.0 +"LivingArea": 2380.0 +"BuildingAreaTotal": 0 +"City": "Menlo Park" +"PostalCode": "94025" +"UnparsedAddress": "3523 Oak Drive, Menlo Park, California 94025" +"Coordinates": array:2 [ …2] +"Latitude": 37.47309796 +"Longitude": -122.19842405 +"YearBuilt": 1978 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Emely Weissman" +"ListOfficeName": "Compass" +"ListAgentMlsId": "ML154192" +"ListOfficeMlsId": "ML37689" +"OriginatingSystemName": "CRMLS" +"PublicRemarks": "This lovely home is set fairly far back, in a picture postcard kind of way, on its 8,370 square foot lot. The neighborhood is a favorite: green, parklike, picturesque, peaceful, great for taking a walk or joining neighbors for the neighborhood's weekly happy hour get together. The wonderful kitchen has handsome cabinetry, spacious granite counters, gas cooking, stainless steel appliances, and a built-in wine refrigerator. There are both a breakfast area and a separate dining room, both family room and living room, and a first floor bedroom that is great as an office. All bathrooms are updated or remodeled; the principal bathroom with oversized tub and shower is particularly luxurious. Hardwood floors throughout main floor, three carpeted bedrooms up and one bedroom on main floor, three skylights. Deck has an excellent built in hot tub, and there is a substantial backyard. This is a terrific place to call home." +"Appliances": "Dishwasher, Disposal, Refrigerator" +"ArchitecturalStyle": "Mediterranean, Traditional" +"AttachedGarageYN": true +"BathroomsFull": 2 +"CLIP": 3251173763 +"CommonWalls": "No Common Walls" +"ContractStatusChangeDate": "2025-05-14" +"Cooling": "None" +"CoolingYN": true +"CountyOrParish": "San Mateo" +"CreationDate": "2025-05-15T02:38:52.962690+00:00" +"DaysOnMarket": 25 +"DaysOnMarketReplication": 25 +"DaysOnMarketReplicationDate": "2025-06-15" +"DaysOnMarketReplicationIncreasingYN": true +"Directions": "Middlefield Road, then turn onto San Benito or Placitas to left on Oak Drive, to 3523. Cross Street: Placitas" +"FireplaceFeatures": "Family Room,Wood Burning" +"FireplaceYN": true +"FoundationDetails": "Concrete Perimeter" +"GarageSpaces": "2.0" +"GarageYN": true +"Heating": "Central" +"HeatingYN": true +"HighSchool": "Menlo-Atherton" +"HighSchoolDistrict": "Other" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "MLSListings" +"ListAgentDirectPhone": "650-814-0374" +"ListAgentEmail": "emely.weissman@compass.com" +"ListAgentFax": "650-323-1143" +"ListAgentFirstName": "Emely" +"ListAgentKey": "20889480" +"ListAgentKeyNumeric": "20889480" +"ListAgentLastName": "Weissman" +"ListAgentOfficePhone": "(650) 323-1111" +"ListAgentStateLicense": "01119038" +"ListOfficeAOR": "MLSListings" +"ListOfficeFax": "650-323-1143" +"ListOfficeKey": "4763954" +"ListOfficeKeyNumeric": "4763954" +"ListOfficePhone": "(650) 323-1111" +"ListOfficeURL": "http://www.compass.com" +"ListingAgreement": "Exclusive Right To Sell" +"ListingContractDate": "2025-05-14" +"ListingKeyNumeric": 1113888520 +"ListingService": "Full Service" +"LivingAreaSource": "Assessor" +"LotFeatures": "Level" +"LotSizeAcres": 0.1921 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 8370.0 +"MLSAreaMajor": "699 - Not Defined" +"MlsStatus": "Active" +"OccupantType": "Owner" +"OnMarketDate": "2025-05-14" +"OnMarketTimestamp": "2025-05-14T12:18:53Z" +"OriginalEntryTimestamp": "2025-05-13T17:00:00Z" …46 } ] +success: true +page_size: 5 +page_count: 135388 +count: 676939 +after_key: "" } ] ]