Availability

Search


Submit

Submit

Master Display Options

Column Display Options

Delaware	Old Baltimore Pike, Newark [view property]	1 Bedroom	View Tour	$825	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,050	View Plan

Maryland	17654 Amity Drive, Gaithersburg [view property]	1 Bedroom (optional den)	View Tour	$1,125 ($1,250)	View Plan

Maryland	17654 Amity Drive, Gaithersburg [view property]	2 Bedroom (optional den)	View Tour	$1,315 ($1,425)	View Plan

Maryland	17654 Amity Drive, Gaithersburg [view property]	3 Bedroom	View Tour	$1,595	View Plan

Maryland	2500 Queens Chapel Road, Hyattsville [view property]	1 Bedroom	View Tour	$1,195	View Plan

Maryland	2500 Queens Chapel Road, Hyattsville [view property]	2 Bedroom - Model A	View Tour	$1,409	View Plan

Maryland	2500 Queens Chapel Road, Hyattsville [view property]	2 Bedroom - Model B	View Tour	$1,409	View Plan

Maryland	2500 Queens Chapel Road, Hyattsville [view property]	3 Bedroom	View Tour	$1,665	View Plan

Maryland	3213 Hewitt Avenue, Wheaton [view property]	1 Bedroom	View Tour	$1,225	View Plan

Maryland	3213 Hewitt Avenue, Wheaton [view property]	2 Bedroom	View Tour	$1,465	View Plan

Maryland	3213 Hewitt Avenue, Wheaton [view property]	2 Bedroom w/Den	View Tour	$1,625	View Plan

Maryland	3213 Hewitt Avenue, Wheaton [view property]	3 Bedroom	View Tour	$1,685	View Plan

Maryland	3213 Hewitt Avenue, Wheaton [view property]	3 Bedroom w/Den	View Tour	$1,750	View Plan

Virginia	10934 Coverstone Drive [view property]	1 Bedroom	View Tour	$1,060	View Plan

Virginia	10934 Coverstone Drive [view property]	2 Bedroom	View Tour	$1,290	View Plan

Virginia	10934 Coverstone Drive [view property]	3 Bedroom	View Tour	$1,500	View Plan

Virginia	11901 Winterthur Lane, Reston [view property]	1 Bedroom (optional loft & den)	View Tour	$1,250 ($1,370 & $1,280)	View Plan

Virginia	11901 Winterthur Lane, Reston [view property]	2 Bedroom (optional loft & den)	View Tour	$1,370 ($1,425 & $1,400)	View Plan

Virginia	11901 Winterthur Lane, Reston [view property]	3 Bedroom (optional loft)	View Tour	$1,550 ($1,675)	View Plan

Virginia	3954 Persimmon Drive, Fairfax [view property]	1 Bedroom Model A	View Tour	$1,280	View Plan

Virginia	3954 Persimmon Drive, Fairfax [view property]	1 Bedroom Model B	View Tour	$1,280	View Plan

Virginia	3954 Persimmon Drive, Fairfax [view property]	1 Bedroom w/Den	View Tour	$1,350	View Plan

Virginia	3954 Persimmon Drive, Fairfax [view property]	2 Bedroom Model A	View Tour	$1,490	View Plan

Virginia	3954 Persimmon Drive, Fairfax [view property]	2 Bedroom Model B, 2 baths	View Tour	$1,605	View Plan

Virginia	3954 Persimmon Drive, Fairfax [view property]	3 Bedroom, 2 baths	View Tour	$1,990	View Plan

Virginia	8547 Richmond Highway, Alexandria [view property]	1 Bedroom Model A	View Tour	$1,095	View Plan

Virginia	8547 Richmond Highway, Alexandria [view property]	1 Bedroom Model B	View Tour	$1,095	View Plan

Virginia	8547 Richmond Highway, Alexandria [view property]	2 Bedroom Model A	View Tour	$1,225	View Plan

Virginia	8547 Richmond Highway, Alexandria [view property]	2 Bedroom Model B	View Tour	$1,225	View Plan

Virginia	8547 Richmond Highway, Alexandria [view property]	2 Bedroom Model C	View Tour	$1,350	View Plan

Virginia	8547 Richmond Highway, Alexandria [view property]	3 Bedroom	View Tour	$1,695	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	Baths	Price	Tour	Floor Plan

43	Delaware	Old Baltimore Pike, Newark [view property]	Iron Hill	1 Bedroom		$825	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,050	View Tour	View Plan
10	Maryland	17654 Amity Drive, Gaithersburg [view property]	Mill Creek	1 Bedroom (optional den)		$1,125 ($1,250)	View Tour	View Plan
11	Maryland	17654 Amity Drive, Gaithersburg [view property]	Mill Creek	2 Bedroom (optional den)		$1,315 ($1,425)	View Tour	View Plan
12	Maryland	17654 Amity Drive, Gaithersburg [view property]	Mill Creek	3 Bedroom		$1,595	View Tour	View Plan
6	Maryland	2500 Queens Chapel Road, Hyattsville [view property]	Queens Park	1 Bedroom		$1,195	View Tour	View Plan
46	Maryland	2500 Queens Chapel Road, Hyattsville [view property]	Queens Park	2 Bedroom - Model A		$1,409	View Tour	View Plan
47	Maryland	2500 Queens Chapel Road, Hyattsville [view property]	Queens Park	2 Bedroom - Model B		$1,409	View Tour	View Plan
9	Maryland	2500 Queens Chapel Road, Hyattsville [view property]	Queens Park	3 Bedroom		$1,665	View Tour	View Plan
13	Maryland	3213 Hewitt Avenue, Wheaton [view property]	Hermitage	1 Bedroom		$1,225	View Tour	View Plan
14	Maryland	3213 Hewitt Avenue, Wheaton [view property]	Hermitage	2 Bedroom		$1,465	View Tour	View Plan
15	Maryland	3213 Hewitt Avenue, Wheaton [view property]	Hermitage	2 Bedroom w/Den		$1,625	View Tour	View Plan
16	Maryland	3213 Hewitt Avenue, Wheaton [view property]	Hermitage	3 Bedroom		$1,685	View Tour	View Plan
17	Maryland	3213 Hewitt Avenue, Wheaton [view property]	Hermitage	3 Bedroom w/Den		$1,750	View Tour	View Plan
21	Virginia	10934 Coverstone Drive [view property]	Coverstone	1 Bedroom		$1,060	View Tour	View Plan
22	Virginia	10934 Coverstone Drive [view property]	Coverstone	2 Bedroom		$1,290	View Tour	View Plan
23	Virginia	10934 Coverstone Drive [view property]	Coverstone	3 Bedroom		$1,500	View Tour	View Plan
18	Virginia	11901 Winterthur Lane, Reston [view property]	Winterthur	1 Bedroom (optional loft & den)		$1,250 ($1,370 & $1,280)	View Tour	View Plan
19	Virginia	11901 Winterthur Lane, Reston [view property]	Winterthur	2 Bedroom (optional loft & den)		$1,370 ($1,425 & $1,400)	View Tour	View Plan
20	Virginia	11901 Winterthur Lane, Reston [view property]	Winterthur	3 Bedroom (optional loft)		$1,550 ($1,675)	View Tour	View Plan
24	Virginia	3954 Persimmon Drive, Fairfax [view property]	Margate	1 Bedroom Model A		$1,280	View Tour	View Plan
25	Virginia	3954 Persimmon Drive, Fairfax [view property]	Margate	1 Bedroom Model B		$1,280	View Tour	View Plan
26	Virginia	3954 Persimmon Drive, Fairfax [view property]	Margate	1 Bedroom w/Den		$1,350	View Tour	View Plan
27	Virginia	3954 Persimmon Drive, Fairfax [view property]	Margate	2 Bedroom Model A		$1,490	View Tour	View Plan
28	Virginia	3954 Persimmon Drive, Fairfax [view property]	Margate	2 Bedroom Model B	, 2 baths	$1,605	View Tour	View Plan
29	Virginia	3954 Persimmon Drive, Fairfax [view property]	Margate	3 Bedroom	, 2 baths	$1,990	View Tour	View Plan
30	Virginia	8547 Richmond Highway, Alexandria [view property]	Washington Square	1 Bedroom Model A		$1,095	View Tour	View Plan
31	Virginia	8547 Richmond Highway, Alexandria [view property]	Washington Square	1 Bedroom Model B		$1,095	View Tour	View Plan
36	Virginia	8547 Richmond Highway, Alexandria [view property]	Washington Square	2 Bedroom Model A		$1,225	View Tour	View Plan
37	Virginia	8547 Richmond Highway, Alexandria [view property]	Washington Square	2 Bedroom Model B		$1,225	View Tour	View Plan
38	Virginia	8547 Richmond Highway, Alexandria [view property]	Washington Square	2 Bedroom Model C		$1,350	View Tour	View Plan
39	Virginia	8547 Richmond Highway, Alexandria [view property]	Washington Square	3 Bedroom		$1,695	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

Maryland

Mill Creek Gardens

Queens Park Plaza

Hermitage

Virginia

Washington Square

Margate Manor

Coverstone I

Coverstone IV

Winterthur

Delaware

Iron Hill

Note: floor plan dimensions are approximate