x
Showing 1 of 0
X
Save

404 MAYAPPLE
Rochester Hills MI 48307 US

$3,200

Active Listing ID 20240093294
bed icon
4 bed
bath icon
3.00 Bath (2 Full , 1 Half)
lot icon
Lot: 0.13 Acres
home icon
Single Family Residence

$3,200

Active Listing ID 20240093294
Save

404 MAYAPPLE Welcome to this beautifully maintained home featuring Brazilian cherry hardwood floors throughout and a custom kitchen with light maple cabinets, Madura gold granite countertops, a full backsplash, and heated Giallo Veneziano granite flooring with coffee brown inserts. The primary suite offers a spa-like retreat with honey onyx tiles, a double sink, a jacuzzi tub, and a separate shower. The guest bathroom is complemented with Crema Marfil marble tiles, double sinks, and a shower/tub combination. Step outside to enjoy the composite deck and a beautifully landscaped backyard featuring a pool and a honeycomb paver patio—perfect for entertaining or relaxing. Located in a quiet neighborhood, this home offers a blend of style, comfort, and functionality.

Collapse all

Property Features

  • Facts
  • Lot Size: 0.13 Acres
  • Property Type: Residential Lease
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 2
  • 1/2 Bathrooms: 1
  • Exterior Finish: Pool - Inground, Pool
  • Heating Fuels: Fireplace, Forced Air
  • Additional Features
  • Fireplace
  • Pool

Property

  • propertytype: Residential Lease
  • propertysubtype: Single Family Residence
  • listprice: 3200
  • unparsedaddress: 404 MAYAPPLE
  • postalcity: Rochester Hills
  • stateorprovince: MI
  • country: US
  • postalcode: 48307
  • bathroomsfull: 2
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.13
  • lotsizeunits: Acres
  • lotsizearea: 0.13
  • livingarea: 2048
  • livingareaunits: Square Feet
  • latitude: 42.631783
  • longitude: -83.12415
  • listagentfullname: Andreea Moldovan
  • listagentemail: andreea@wearedobi.com
  • listagentkey: 3yd-REALCOMPMI-389372
  • listagentmlsid: 389372
  • listagentpreferredphone: 3139996916
  • listagentofficephone: 2483853350
  • listofficekey: 3yd-REALCOMPMI-403268
  • listofficemlsid: 403268
  • disclaimer: Copyright © 2024 Realcomp Limited II. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: REALCOMPMI
  • yearbuilt: 1989
  • listingcontractdate: 2024-12-19
  • listagenturl: https://activestatesgroup.com
  • countyorparish: Oakland
  • parcelnumber: 1535177014
  • elementaryschooldistrict: Rochester
  • middleorjuniorschooldistrict: Rochester
  • highschooldistrict: Rochester
  • appliances: Dishwasher, Dryer, Garbage Disposer, Microwave, Range, Range - Gas, Refrigerator, Washer
  • constructionmaterials: Brick
  • heating: Fireplace, Forced Air
  • fireplaceyn: True
  • transactiontype: ForRent
  • storiestotal: 2
  • parkingtotal: 0
  • parkingfeatures: Garage
  • waterfrontyn: False
  • interiorfeatures: Furnished - Partially
  • exteriorfeatures: Pool - Inground, Pool
  • architecturalstyle: Colonial
  • rooms: Basement, Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4
  • dock: False
  • poolprivateyn: True
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -83.12415, 42.631783
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"DOBI Real Estate", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "Expenses":[{"ExpenseCategory":"Application Fee", "ExpenseFrequency":"Once", "ExpenseValue":40}, {"ExpenseCategory":"Security Deposit", "ExpenseFrequency":"Once", "ExpenseValue":4800}], "GeocodeOptions":null, "LeadRoutingEmail":"andreea@wearedobi.com", "ListBrokerageCity":"Birmingham", "ListBrokerageCountry":"US", "ListBrokerageEmail":"hello@wearedobi.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/REALCOMPMI/23921521946711eaacfb0242ac110004/20200526143836155.png", "ListBrokerageName":"DOBI Real Estate", "ListBrokeragePhone":"(248) 385-3350", "ListBrokeragePostalCode":"48009", "ListBrokerageStateOrProvince":"MI", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"2211 Cole Street", "ListBrokerageWebsiteUrl":"https://wearedobi.com/", "ListOfficeAddress1":"2211 Cole Street", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"369681", "ListOfficeCity":"Birmingham", "ListOfficeCountry":"US", "ListOfficeEmail":"hello@wearedobi.com", "ListOfficePostalCode":"48009", "ListOfficeStateOrProvince":"MI", "ListPriceCurrencyType":"USD", "ListingTitle":"Colonial - Rochester Hills, MI", "ListingURL":"https://www.realtor.com/rentals/details/404-Mayapple-Ct_Rochester-Hills_MI_48307_M40342-42105?f=listhub&s=REALCOMPMI&m=20240093294&c=rexren", "MLSModificationTimestamp":"2024-12-19T18:24:20Z", "Neighborhoods":[{"Description":null, "Name":"Rochester Hills"}], "PostalCode":null, "RoomCount":9, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 12/20/2024 6:04:47 AM GMT
Source Updated Date: 12/26/2024 6:52:58 AM GMT

Courtesy of: Andreea Moldovan, DOBI Real Estate, andreea@wearedobi.com

Copyright © 2024 Realcomp Limited II. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.