Availability

Search


Submit

Submit

Master Display Options

Column Display Options

Delaware	Old Baltimore Pike, Newark [view property]	1 Bedroom	View Tour	$799	View Plan

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

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

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

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

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

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

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

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

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

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

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

Maryland	3213 Hewitt Avenue, Wheaton [view property]	3 Bedroom w/Den	View Tour	$1,650	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,270	View Plan

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

Virginia	11901 Winterthur Lane, Reston [view property]	1 Bedroom (optional loft & den)	View Tour	$1,225 ($1,255 & $1,345)	View Plan

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

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

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

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

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

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

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

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

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

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

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

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

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

Virginia	8547 Richmond Highway, Alexandria [view property]	3 Bedroom	View Tour	$1,645	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		$799	View Tour	View Plan
44	Delaware	Old Baltimore Pike, Newark [view property]	Iron Hill	2 Bedroom		$925	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,050 ($1,100)	View Tour	View Plan
11	Maryland	17654 Amity Drive, Gaithersburg [view property]	Mill Creek	2 Bedroom (optional den)		$1,150 ($1,200)	View Tour	View Plan
12	Maryland	17654 Amity Drive, Gaithersburg [view property]	Mill Creek	3 Bedroom		$1,325	View Tour	View Plan
6	Maryland	2500 Queens Chapel Road, Hyattsville [view property]	Queens Park	1 Bedroom		$1,060	View Tour	View Plan
46	Maryland	2500 Queens Chapel Road, Hyattsville [view property]	Queens Park	2 Bedroom - Model A		$1,175	View Tour	View Plan
47	Maryland	2500 Queens Chapel Road, Hyattsville [view property]	Queens Park	2 Bedroom - Model B		$1,175	View Tour	View Plan
9	Maryland	2500 Queens Chapel Road, Hyattsville [view property]	Queens Park	3 Bedroom		$1,410	View Tour	View Plan
13	Maryland	3213 Hewitt Avenue, Wheaton [view property]	Hermitage	1 Bedroom		$1,175	View Tour	View Plan
14	Maryland	3213 Hewitt Avenue, Wheaton [view property]	Hermitage	2 Bedroom		$1,300	View Tour	View Plan
15	Maryland	3213 Hewitt Avenue, Wheaton [view property]	Hermitage	2 Bedroom w/Den		$1,500	View Tour	View Plan
16	Maryland	3213 Hewitt Avenue, Wheaton [view property]	Hermitage	3 Bedroom		$1,575	View Tour	View Plan
17	Maryland	3213 Hewitt Avenue, Wheaton [view property]	Hermitage	3 Bedroom w/Den		$1,650	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,270	View Tour	View Plan
23	Virginia	10934 Coverstone Drive [view property]	Coverstone	3 Bedroom		$1,495	View Tour	View Plan
18	Virginia	11901 Winterthur Lane, Reston [view property]	Winterthur	1 Bedroom (optional loft & den)		$1,225 ($1,255 & $1,345)	View Tour	View Plan
19	Virginia	11901 Winterthur Lane, Reston [view property]	Winterthur	2 Bedroom (optional loft & den)		$1,345 ($1,375 & $1,400)	View Tour	View Plan
20	Virginia	11901 Winterthur Lane, Reston [view property]	Winterthur	3 Bedroom (optional loft)		$1,525 ($1,650)	View Tour	View Plan
24	Virginia	3954 Persimmon Drive, Fairfax [view property]	Margate	1 Bedroom Model A		$1,275	View Tour	View Plan
25	Virginia	3954 Persimmon Drive, Fairfax [view property]	Margate	1 Bedroom Model B		$1,275	View Tour	View Plan
26	Virginia	3954 Persimmon Drive, Fairfax [view property]	Margate	1 Bedroom w/Den		$1,475	View Tour	View Plan
27	Virginia	3954 Persimmon Drive, Fairfax [view property]	Margate	2 Bedroom Model A		$1,475	View Tour	View Plan
28	Virginia	3954 Persimmon Drive, Fairfax [view property]	Margate	2 Bedroom Model B	, 2 baths	$1,575	View Tour	View Plan
29	Virginia	3954 Persimmon Drive, Fairfax [view property]	Margate	3 Bedroom	, 2 baths	$1,875	View Tour	View Plan
30	Virginia	8547 Richmond Highway, Alexandria [view property]	Washington Square	1 Bedroom Model A		$1,075	View Tour	View Plan
31	Virginia	8547 Richmond Highway, Alexandria [view property]	Washington Square	1 Bedroom Model B		$1,075	View Tour	View Plan
36	Virginia	8547 Richmond Highway, Alexandria [view property]	Washington Square	2 Bedroom Model A		$1,275	View Tour	View Plan
37	Virginia	8547 Richmond Highway, Alexandria [view property]	Washington Square	2 Bedroom Model B		$1,275	View Tour	View Plan
38	Virginia	8547 Richmond Highway, Alexandria [view property]	Washington Square	2 Bedroom Model C		$1,275	View Tour	View Plan
39	Virginia	8547 Richmond Highway, Alexandria [view property]	Washington Square	3 Bedroom		$1,645	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