2790 Castlemartin Court, Unit 15

4,028 Sq. Ft.
$92 / Sq. Ft.
4,028
Sq. Ft.
$92
per Sq. Ft.

Description

Moceri Duet Condo is better than new and shows like a model. Tons of upgrades w/ 4 bedrooms 3.5 baths, three-car side turn garage , finished walkout lower-level, with second kitchen, fourth bedroom and bath. Large open floor plan, Brazilian cherry hardwood floors, cherry cabinetry throughout, first floor master, with jetted tub and separate shower, dual sinks and granite counter tops. Patio and deck, Upgrade Feature List and Exclusion Sheet Online.Moceri Duet Condo is better than new and shows like a model. Tons of upgrades w/ 4 bedrooms 3.5 baths, three-car side turn garage , finished walkout lower-level, with second kitchen, fourth bedroom and bath. Large open floor plan, Brazilian cherry hardwood floors, cherry cabinetry throughout, first floor master, with jetted tub and separate shower, dual sinks and granite counter tops. Patio and deck, Upgrade Feature List and Exclusion Sheet Online.
  1. Listed by Linda Rea • Brokerage DRE #6503288502 • REAL ESTATE ONE-TROY
    P: (248)-709-3786 C: (248)-709-3786 lindarea@comcast.net

Property Details for 2790 Castlemartin Court, Unit 15

Subdivision Name
CLAREMONT AT OAKLANDS OCCPN 1239
Waterfront
No
LISTING CLOSED: 05/15/2012 12:00 AM

Property Details for 2790 Castlemartin Court, Unit 15

StatusSold
MLS #212020347
Days on Market48
Pet Policy-
Taxes$3,724 / year
HOA Fees$342 / month
Condo/Co-op Fees-
Property TypeCondo
MLS TypeResidential / Condominium
Year Built2004
CountyOakland County

Location

Listing Courtesy of REAL ESTATE ONE-TROY

Sold By REAL ESTATE ONE-ROCHESTER

Add your commute

Building Information for 2790 Castlemartin Court, Unit 15

Building/Complex2790 Castlemartin CtFloor-Stories-Residences-Pet Policy-Pet Policy Details-Year Built2004

Payment Calculator

$2,533 per month

30 year fixed, 6.55% Interest

Principal and Interest

$1,881

Property Taxes

$310

HOA Dues

$342

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 2790 Castlemartin Court, Unit 15

Summary
Location and General Information
  • Directions: LOCATED ON THE SOUTH SIDE SILVERBELL
  • Latitude: 42.722515
  • Longitude: -83.192398
  • Cross Street: S of Silverbell/E of Adams
  • MLS Area Major: Area02101Oakland Twp
Taxes and HOA
  • Association Fee: $342.00
  • Parcel Number: 1032101015
  • Tax Amount Summer: $2,375.00
  • Tax Amount Winter: $1,349.00
  • Tax Annual Amount: $3,724.00
  • Tax Legal Description: T4N, R11E, SEC 32 OAKLAND COUNTY CONDOMINIUM PLAN NO 1239 CLAREMONT AT OAKLANDS UNIT 15 L 21136 P 737 2-29-00 FR 100-002
  • Association Fee Frequency: Monthly
  • Association: Yes
School Information
  • High School District: Rochester
Parking
  • Garage Spaces: 3.0
  • Garage: Yes
  • Parking Features: Three Car Garage
Property
Lot Information
  • Road Frontage Type: Paved
Property and Assessments
  • Living Area: 4028.0
  • Above Grade Finished Area: 2310.0
  • Below Grade Finished Area: 1718.0
  • Above Grade Finished Area Units: Square Feet
  • Below Grade Finished Area Units: Square Feet
  • Class Name: Residential
  • Living Area Source: Builder
  • Living Area Units: Square Feet
  • Year Built: 2004
Building Features
  • Construction Materials: Brick, Wood Siding
  • Foundation Details: Basement
  • Levels: One And One Half
Utilities
  • Sewer: Public Sewer
  • Water Source: Community
Interior and Exterior Features
Interior Features
  • Bathrooms Total Notational: 3.1
  • Appliances: Dishwasher, Disposal, Dryer, Refrigerator, Range, Washer
  • Basement: Finished, Walk Out Access
  • Has Basement: Yes
  • Bathrooms Full: 3
  • Bathrooms Half: 1
  • Bathrooms Total Integer: 4
  • Bedrooms Total: 4
  • Fireplace: No
  • Heating: Forced Air, Natural Gas
  • Has Heating: Yes
  • Rooms Total: 9
Room Information
Room 1
  • Room Level: Lower
  • Room Type: Bath Full
Room 2
  • Room Dimensions: 23x12
  • Room Length: 23.0
  • Room Width: 12.0
  • Room Length Width Units: Feet
  • Room Level: Entry
  • Room Type: Kitchen
Room 3
  • Room Level: Upper
  • Room Type: Bath Full
Room 4
  • Room Dimensions: 16x1
  • Room Length: 16.0
  • Room Width: 1.0
  • Room Length Width Units: Feet
  • Room Level: Entry
  • Room Type: Dining Room
Room 5
  • Room Dimensions: 18x11
  • Room Length: 18.0
  • Room Width: 11.0
  • Room Length Width Units: Feet
  • Room Level: Upper
  • Room Type: Bedroom
Room 6
  • Room Dimensions: 12x14
  • Room Length: 12.0
  • Room Width: 14.0
  • Room Length Width Units: Feet
  • Room Level: Lower
  • Room Type: Bedroom
Room 7
  • Room Dimensions: 15x25
  • Room Length: 15.0
  • Room Width: 25.0
  • Room Length Width Units: Feet
  • Room Level: Entry
  • Room Type: Family Room
Room 8
  • Room Dimensions: 15x32
  • Room Length: 15.0
  • Room Width: 32.0
  • Room Length Width Units: Feet
  • Room Level: Entry
  • Room Type: Great Room
Room 9
  • Room Level: Entry
  • Room Type: Bath Full
Room 10
  • Room Dimensions: 11x12
  • Room Length: 11.0
  • Room Width: 12.0
  • Room Length Width Units: Feet
  • Room Level: Entry
  • Room Type: Bedroom
Room 11
  • Room Dimensions: 16x09
  • Room Length: 16.0
  • Room Width: 9.0
  • Room Length Width Units: Feet
  • Room Level: Entry
  • Room Type: Laundry
Room 12
  • Room Level: Entry
  • Room Type: Primary Bathroom
Agent
Sale and Listings
  • Public GLR Website: Yes

Property History for 2790 Castlemartin Court, Unit 15

DateEvent & SourcePriceAppreciation
May 15, 2012

Sold

Realcomp #212020347

$370,000
Apr 16, 2012

Contract Signed

Realcomp #212020347

Feb 28, 2012

Listed (Active)

Realcomp #212020347

$385,000
DateEvent & SourcePrice
05/15/2012

Sold

Realcomp #212020347

$370,000
04/16/2012

Contract Signed

Realcomp #212020347

02/28/2012

Listed (Active)

Realcomp #212020347

$385,000

For completeness, we often displays two records for one sale: the MLS record and the public record.

Schools near 2790 Castlemartin Court, Unit 15

This home is within Rochester Community School District.
Rating
School
Type
Grades
Distance
Public - PK to 5
Public - 6 to 12
Public - 7 to 12
Public - 9 to 12
Rating
School
Distance
Delta Kelly Elementary School
PublicPK to 5

Van Hoosen Middle School
Public6 to 12

Rochester Adams High School
Public7 to 12

John M Schultz Educational Campus
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Nearby off-market homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of REAL ESTATE ONE-TROY

IDX provided courtesy of Realcomp II Ltd. via Compass and its related brokerages. Copyright 2026 Realcomp II Ltd. Shareholders. IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. The data relating to real estate properties on this website was last updated on 09/26/2023 05:36 AM PST