select mris_sold.hvid,mris_sold.hvid as id, mris_sold.mrisNo, mris_sold.address, mris_sold.city, mris_sold.state, mris_sold.zip, mris_sold.price, mris_sold.subdivision, mris_sold.bedroom, mris_sold.fullBath, mris_sold.halfBath, mris_sold.date_sold, mris_sold.sale_price, mris_sold.mrisPhoto as mlsPhoto, home.mrisPhoto, mris_sold.agent_id_1,mris_sold.agent_id_2,mris_sold.sale_agent_id from mris_sold left join home on mris_sold.hvID=home.id where sale_price>0 and (mris_sold.agent_id_1='' or mris_sold.agent_id_2='' or mris_sold.sale_agent_id='') order by date_sold desc
Row Count-1
WASHINGTON FINE PROPERTIES

PROPERTY SEARCH

Address, Subdiv, City or MLS#:

State:

Listing Price:

 

to

 

Year:

VIEW:    Gallery List
0 Matching Listings
CROSSWINDS 3013   $83,500
26 CHESAPEAKE CT
BARNEGAT, NJ 08005
1 Beds, 1 Baths

Full Details 

 
 
MANAHAWKIN 2913   $369,000
969 SANDY CIRCLE
MANAHAWKIN, NJ 08050
4 Beds, 3 Baths, 1 Half Baths

Full Details 

 
 
WEST BAY VILLAGE 2103   $22,000
9 PINE CONE LANE
MANAHAWKIN, NJ 08050
2 Beds, 1 Baths

Full Details 

 
 
SHIP BOTTOM 2103   $394,000
363 W 8TH
SHIP BOTTOM, NJ 08008
3 Beds, 2 Baths

Full Details 

 
 
BARNEGAT 2027   $140,000
23 TWAIN AVE
BARNEGAT, NJ 08005
3 Beds, 1 Baths

Full Details 

 
 
FOREST HILLS 2020   $129,500
40 RIDGEWOOD RD
LANCASTER TWP, PA 17603
3 Beds, 1 Baths, 1 Half Baths

Full Details 

 
 
CROYDON PARK 2020   $399,990
302 CROYDON AVE
ROCKVILLE, MD 20850
5 Beds, 3 Baths

Full Details 

 
 
SUNNYSIDE 2020   $641,500
3846 CHARLES AVE
ALEXANDRIA, VA 22305
3 Beds, 2 Baths, 2 Half Baths

Full Details 

 
 
WISSINOMING 2020   $75,000
2131 LARUE ST
PHILADELPHIA, PA 19124
3 Beds, 1 Baths

Full Details 

 
 
BURN BRAE 2020   $75,000
206-A HIGHLAND BLVD
NEW CASTLE, DE 19720
2 Beds, 2 Baths

Full Details