Corporate Offices Rockville, MD
Apartments
Availability
Resident Portal
Apply Online
Contact Us
Maryland
Mill Creek Gardens
Queens Park Plaza
Hermitage
Virginia
Washington Square
Margate Manor
Coverstone I
Coverstone IV
Winterthur
Delaware
Iron Hill
Current Availability
Search
Submit
Master Display Options
Column Display Options
Delaware
Old Baltimore Pike, Newark
[view property]
1 Bedroom
View Tour
$800
View Plan
Delaware
Old Baltimore Pike, Newark
[view property]
2 Bedroom
View Tour
$950
View Plan
Delaware
Old Baltimore Pike, Newark
[view property]
3 Bedroom
View Tour
$1,000
View Plan
Maryland
17654 Amity Drive, Gaithersburg
[view property]
1 Bedroom (optional den)
View Tour
$1,100 ($1,160)
View Plan
Maryland
17654 Amity Drive, Gaithersburg
[view property]
2 Bedroom (optional den)
View Tour
$1,295 ($1,395)
View Plan
Maryland
17654 Amity Drive, Gaithersburg
[view property]
3 Bedroom
View Tour
$1,560
View Plan
Maryland
2500 Queens Chapel Road, Hyattsville
[view property]
1 Bedroom
View Tour
$1,000
View Plan
Maryland
2500 Queens Chapel Road, Hyattsville
[view property]
2 Bedroom - Model A
View Tour
$1,200
View Plan
Maryland
2500 Queens Chapel Road, Hyattsville
[view property]
2 Bedroom - Model B
View Tour
$1,200
View Plan
Maryland
2500 Queens Chapel Road, Hyattsville
[view property]
3 Bedroom
View Tour
$1,350
View Plan
Maryland
3213 Hewitt Avenue, Wheaton
[view property]
1 Bedroom
View Tour
$1,195
View Plan
Maryland
3213 Hewitt Avenue, Wheaton
[view property]
2 Bedroom
View Tour
$1,500
View Plan
Maryland
3213 Hewitt Avenue, Wheaton
[view property]
2 Bedroom w/Den
View Tour
$1,595
View Plan
Maryland
3213 Hewitt Avenue, Wheaton
[view property]
3 Bedroom
View Tour
$1,620
View Plan
Maryland
3213 Hewitt Avenue, Wheaton
[view property]
3 Bedroom w/Den
View Tour
$1,670
View Plan
Virginia
10934 Coverstone Drive
[view property]
1 Bedroom
View Tour
$1,025
View Plan
Virginia
10934 Coverstone Drive
[view property]
2 Bedroom
View Tour
$1,145
View Plan
Virginia
10934 Coverstone Drive
[view property]
3 Bedroom
View Tour
$1,450
View Plan
Virginia
11901 Winterthur Lane, Reston
[view property]
1 Bedroom (optional loft & den)
View Tour
$1,260 ($1,345 & $1,290)
View Plan
Virginia
11901 Winterthur Lane, Reston
[view property]
2 Bedroom (optional loft & den)
View Tour
$1,380 ($1,435 & $1,400)
View Plan
Virginia
11901 Winterthur Lane, Reston
[view property]
3 Bedroom (optional loft)
View Tour
$1,525 ($1,600)
View Plan
Virginia
3954 Persimmon Drive, Fairfax
[view property]
1 Bedroom Model A
View Tour
$1,270
View Plan
Virginia
3954 Persimmon Drive, Fairfax
[view property]
1 Bedroom Model B
View Tour
$1,270
View Plan
Virginia
3954 Persimmon Drive, Fairfax
[view property]
1 Bedroom w/Den
View Tour
$1,325
View Plan
Virginia
3954 Persimmon Drive, Fairfax
[view property]
2 Bedroom Model A
View Tour
$1,470
View Plan
Virginia
3954 Persimmon Drive, Fairfax
[view property]
2 Bedroom Model B, 2 baths
View Tour
$1,585
View Plan
Virginia
3954 Persimmon Drive, Fairfax
[view property]
3 Bedroom, 2 baths
View Tour
$1,935
View Plan
Virginia
8547 Richmond Highway, Alexandria
[view property]
1 Bedroom Model A
View Tour
$1,060
View Plan
Virginia
8547 Richmond Highway, Alexandria
[view property]
1 Bedroom Model B
View Tour
$1,060
View Plan
Virginia
8547 Richmond Highway, Alexandria
[view property]
2 Bedroom Model A
View Tour
$1,210
View Plan
Virginia
8547 Richmond Highway, Alexandria
[view property]
2 Bedroom Model B
View Tour
$1,260
View Plan
Virginia
8547 Richmond Highway, Alexandria
[view property]
2 Bedroom Model C
View Tour
$1,260
View Plan
Virginia
8547 Richmond Highway, Alexandria
[view property]
3 Bedroom
View Tour
$1,610
View Plan
First
Prev
Page: 1 of 1
Next
Last
Drag a column header and drop it here to group by that column
ID
State
Complex Name
Address
Apt Type
Bed Rooms
Baths
Price
Tour
Floor Plan
43
Delaware
Old Baltimore Pike, Newark
[view property]
Iron Hill
1 Bedroom
$800
View Tour
View Plan
44
Delaware
Old Baltimore Pike, Newark
[view property]
Iron Hill
2 Bedroom
$950
View Tour
View Plan
45
Delaware
Old Baltimore Pike, Newark
[view property]
Iron Hill
3 Bedroom
$1,000
View Tour
View Plan
10
Maryland
17654 Amity Drive, Gaithersburg
[view property]
Mill Creek
1 Bedroom (optional den)
$1,100 ($1,160)
View Tour
View Plan
11
Maryland
17654 Amity Drive, Gaithersburg
[view property]
Mill Creek
2 Bedroom (optional den)
$1,295 ($1,395)
View Tour
View Plan
12
Maryland
17654 Amity Drive, Gaithersburg
[view property]
Mill Creek
3 Bedroom
$1,560
View Tour
View Plan
6
Maryland
2500 Queens Chapel Road, Hyattsville
[view property]
Queens Park
1 Bedroom
$1,000
View Tour
View Plan
46
Maryland
2500 Queens Chapel Road, Hyattsville
[view property]
Queens Park
2 Bedroom - Model A
$1,200
View Tour
View Plan
47
Maryland
2500 Queens Chapel Road, Hyattsville
[view property]
Queens Park
2 Bedroom - Model B
$1,200
View Tour
View Plan
9
Maryland
2500 Queens Chapel Road, Hyattsville
[view property]
Queens Park
3 Bedroom
$1,350
View Tour
View Plan
13
Maryland
3213 Hewitt Avenue, Wheaton
[view property]
Hermitage
1 Bedroom
$1,195
View Tour
View Plan
14
Maryland
3213 Hewitt Avenue, Wheaton
[view property]
Hermitage
2 Bedroom
$1,500
View Tour
View Plan
15
Maryland
3213 Hewitt Avenue, Wheaton
[view property]
Hermitage
2 Bedroom w/Den
$1,595
View Tour
View Plan
16
Maryland
3213 Hewitt Avenue, Wheaton
[view property]
Hermitage
3 Bedroom
$1,620
View Tour
View Plan
17
Maryland
3213 Hewitt Avenue, Wheaton
[view property]
Hermitage
3 Bedroom w/Den
$1,670
View Tour
View Plan
21
Virginia
10934 Coverstone Drive
[view property]
Coverstone
1 Bedroom
$1,025
View Tour
View Plan
22
Virginia
10934 Coverstone Drive
[view property]
Coverstone
2 Bedroom
$1,145
View Tour
View Plan
23
Virginia
10934 Coverstone Drive
[view property]
Coverstone
3 Bedroom
$1,450
View Tour
View Plan
18
Virginia
11901 Winterthur Lane, Reston
[view property]
Winterthur
1 Bedroom (optional loft & den)
$1,260 ($1,345 & $1,290)
View Tour
View Plan
19
Virginia
11901 Winterthur Lane, Reston
[view property]
Winterthur
2 Bedroom (optional loft & den)
$1,380 ($1,435 & $1,400)
View Tour
View Plan
20
Virginia
11901 Winterthur Lane, Reston
[view property]
Winterthur
3 Bedroom (optional loft)
$1,525 ($1,600)
View Tour
View Plan
24
Virginia
3954 Persimmon Drive, Fairfax
[view property]
Margate
1 Bedroom Model A
$1,270
View Tour
View Plan
25
Virginia
3954 Persimmon Drive, Fairfax
[view property]
Margate
1 Bedroom Model B
$1,270
View Tour
View Plan
26
Virginia
3954 Persimmon Drive, Fairfax
[view property]
Margate
1 Bedroom w/Den
$1,325
View Tour
View Plan
27
Virginia
3954 Persimmon Drive, Fairfax
[view property]
Margate
2 Bedroom Model A
$1,470
View Tour
View Plan
28
Virginia
3954 Persimmon Drive, Fairfax
[view property]
Margate
2 Bedroom Model B
, 2 baths
$1,585
View Tour
View Plan
29
Virginia
3954 Persimmon Drive, Fairfax
[view property]
Margate
3 Bedroom
, 2 baths
$1,935
View Tour
View Plan
30
Virginia
8547 Richmond Highway, Alexandria
[view property]
Washington Square
1 Bedroom Model A
$1,060
View Tour
View Plan
31
Virginia
8547 Richmond Highway, Alexandria
[view property]
Washington Square
1 Bedroom Model B
$1,060
View Tour
View Plan
36
Virginia
8547 Richmond Highway, Alexandria
[view property]
Washington Square
2 Bedroom Model A
$1,210
View Tour
View Plan
37
Virginia
8547 Richmond Highway, Alexandria
[view property]
Washington Square
2 Bedroom Model B
$1,260
View Tour
View Plan
38
Virginia
8547 Richmond Highway, Alexandria
[view property]
Washington Square
2 Bedroom Model C
$1,260
View Tour
View Plan
39
Virginia
8547 Richmond Highway, Alexandria
[view property]
Washington Square
3 Bedroom
$1,610
View Tour
View Plan
Executed SQL -
SELECT a.ID AS ID, s.Name AS State, CASE WHEN p.URL IS NULL THEN p.ComplexName ELSE p.ComplexName + '
[view property]
' END AS ComplexName, a.Address AS Address, a.AptType AS AptType, CASE WHEN a.BedRooms IS NULL OR a.BedRooms = '' THEN a.BedRooms ELSE ', ' + a.BedRooms END AS BedRooms, CASE WHEN a.Baths IS NULL OR a.Baths = '' THEN a.Baths ELSE ', '+a.Baths END AS Baths, a.Price AS Price, CASE WHEN a.Tour IS NULL THEN '' ELSE '
View Tour
' END AS Tour, CASE WHEN a.FloorPlan IS NULL THEN '' ELSE '
View Plan
' END AS FloorPlan FROM dbo.RIMSI_Apartment AS a INNER JOIN dbo.RIMSI_Property AS p ON (a.PropertyID = p.ID) INNER JOIN dbo.RIMSI_State AS s ON (a.StateID = s.ID) WHERE a.Active='True' ORDER BY s.Name, p.ComplexName, a.AptType
Note: floor plan dimensions are approximate
© Copyright 2018
PRIVACY
TERMS