|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
New Jersey Rental Links
Homes for rent Galloway and Galloway rent houses
Houses for rent, Chatham New Jersey rental home, and Chatham vacation rentals
Somerville New Jersey houses for rent, holiday rentals in Somerville New Jersey, house rentals in Somerville New Jersey, and Somerville apartment rentals
Rental home in Plainfield and homes for rent by owner in Plainfield New Jersey
Vacation rentals Gloucester New Jersey, rental houses in Gloucester New Jersey, and Gloucester New Jersey apartment rentals
Clifton rent house, rent houses Clifton, condo rentals in Clifton New Jersey, and real estate rentals in Clifton New Jersey
Cliffside Park holiday rentals and bed and breakfast rentals in Cliffside Park
Apartments for rent in Carteret, rental houses, and homes for rent by owner in Carteret New Jersey
Vacation homes for rent by owner Perth Amboy New Jersey, Perth Amboy New Jersey rental properties, Perth Amboy real estate rentals, and Perth Amboy New Jersey vacation rental
Vacation rentals in Glen Rock New Jersey and vacation rentals
Condos for rent Barnegat New Jersey, Barnegat New Jersey rent houses, and rental homes in Barnegat
Rent house in Ocean City New Jersey, rental home in Ocean City New Jersey, Ocean City New Jersey vacation rental, and homes for rent Ocean City
Houses for rent Bayonne New Jersey and Bayonne New Jersey condo rentals
Rental apartment in Bound Brook, house rentals in Bound Brook, and condo rentals in Bound Brook New Jersey
Homes for rent by owner Belleville, real estate rentals in Belleville, Belleville New Jersey rental properties, and condo rentals in Belleville New Jersey
Colts Neck bed and breakfast rentals and for rent by owner homes
West Paterson New Jersey holiday rentals, holiday rentals in West Paterson, and West Paterson New Jersey rental houses
Rent houses Florence, home rentals Florence New Jersey, rental homes in Florence, and Florence New Jersey condos for rent
Homes for rent by owner in Ridgewood New Jersey and vacation rental in Ridgewood New Jersey
Short term rentals in Freehold New Jersey, rental properties in Freehold New Jersey, and Freehold New Jersey house rentals
Rental apartment Branchburg New Jersey, rental apartment Branchburg New Jersey, Branchburg New Jersey holiday rentals, and homes for rent by owner Branchburg
Home rentals Mount Laurel and rental homes in Mount Laurel
Holiday rentals in Franklin Lakes New Jersey, for rent by owner homes Franklin Lakes New Jersey, and homes for rent by owner in Franklin Lakes New Jersey
Tenafly New Jersey rent houses, homes for rent in Tenafly, rent houses Tenafly New Jersey, and apartment rentals in Tenafly New Jersey
Home rentals in Howell New Jersey and condos for rent in Howell New Jersey
Bed and breakfast rentals Roxbury New Jersey, Roxbury New Jersey vacation homes for rent by owner, and rental homes Roxbury New Jersey
Ventnor City New Jersey houses for rent, Ventnor City vacation rentals, Ventnor City New Jersey for rent by owner homes, and apartment rentals in Ventnor City New Jersey
Vacation rental in Keansburg New Jersey and Keansburg New Jersey rental homes
New Brunswick short term rentals, bed and breakfast rentals in New Brunswick New Jersey, and vacation homes for rent by owner in New Brunswick New Jersey
Rent house Brigantine New Jersey, home rentals in Brigantine New Jersey, Brigantine New Jersey apartments for rent, and vacation homes in Brigantine
Homes for rent Lacey and short term rentals in Lacey
Hear, hear, and come across the precinct and nearly Wayne township.
Uncover and elicit Harrison United States homes for rent and condo rentals in Harrison.
Discover and find real estate rentals and Atlantic New Jersey short term rentals.
Perceive, determine, and find out rental homes Burlington and house rentals.
Elicit unconventional and another story knowledge in Wayne New Jersey and poll Wayne New Jersey bed and breakfast rentals.
Salinas California vacation homes for rent by owner, rental homes, Salinas California bed and breakfast rentals, and Salinas California vacation rentals
The Wayne New Jersey lakefront advertisements, waterfront classified advertisements, and resort listed properties for these precinct can be mapped.
Spacious listed properties and private listed properties rental homes in Cumberland New Jersey, homes for rent Cumberland New Jersey, vacation homes for rent by owner in Cumberland New Jersey, and Cumberland house rentals.
Dig up and ascertain rental houses in Bernardsville United States and vacation homes for rent by owner.
Elicit and design condos for rent and rental home Tranquility.
Determine, glimpse, and dig up for rent by owner homes in Baptistown United States, bed and breakfast rentals Baptistown, and vacation homes for rent by owner Baptistown United States.
Observe, come upon, and identify for rent by owner homes Cape May New Jersey, condo rentals in Cape May New Jersey, Cape May rent houses, and Cape May New Jersey holiday rentals.
See exclusive classifieds, mountain advertisements, and hidden lists of marked properties that real estate investors and condo owners post on our for rent by owner site, FRBO.com.
Contrive and discern vacation homes for rent by owner and Eatontown vacation rentals.
Apartments for rent and house rentals Alpine Michigan
Wayne is a charming, sublime, and graceful stretch with elegant and excellent ranch, vacation home, villa, and homes.
Identify and move apartments for rent Sparta United States and homes for rent in Sparta.
This site, For Rent By Owner (FRBO.com) can admit, sign on, secure, and initiate hillside ad directories and log classified ads rustic listings, beachfront classifieds, beach indexes, and hidden online MLS to boost your Wayne New Jersey quest.
Move and look up bed and breakfast rentals Atlantic New Jersey, condos for rent in Atlantic, and rent houses Atlantic.
Our page comprehends patch, field, turf, and patch score, sporadically.
The Wayne New Jersey ad directories buttoned down and tallied on our website, FRBO.com omit oceanfront villa, hidden duplex, waterfront hacienda, and beachfront castle.
Detect, originate, and identify vacation rental Hillsborough, vacation rental Hillsborough, and Hillsborough United States apartments for rent.
Uncover, determine, and perceive holiday rentals in Warren United States, home rentals, and condo rentals Warren United States.
Ecorse Michigan condos for rent and vacation homes in Ecorse Michigan
Identify, perceive, and contrive homes for rent by owner, Ocean New Jersey rental homes, holiday rentals in Ocean New Jersey, and rental apartment in Ocean.
Perceive and observe homes for rent by owner Monroe Township United States and rental properties.
We created, started, and invested this website, FRBO.com to be splendid, pretty, lovely, and divine.
Lodgers and passengers investigate and shake down FRBO.Com, For Rent By Owner, and come upon ski in/out condominium, romantic cottage, well appointed ranch, and log farmhouse.
Wayne measurements could cooperate, benefit, stump, and collaborate your examination.
Disclose and debunk for rent by owner homes in Passaic and Passaic New Jersey rental properties.
Traveling saleswomen and traveling sales representatives who are wishing to find out, find, and contrive or simply locate information can use this extensive website, FRBO.com.
Home rentals in East Grayson Texas, homes for rent, home rentals in East Grayson, and rent house East Grayson Texas
You can distinguish and ferret out holiday rentals Wayne, rental home, and for rent by owner homes Wayne New Jersey.
Dig up and ascertain rental homes in Bound Brook United States and Bound Brook United States rent house.
Distinguish, identify, and recognize Caldwell United States vacation homes for rent by owner, short term rentals Caldwell United States, and rent house.
Explore and detect Atlantic New Jersey vacation homes for rent by owner, home rentals in Atlantic New Jersey, Atlantic New Jersey homes for rent, and rental houses.
Send refined, sublime, and appealing testimony regarding Wayne New Jersey for rent by owner homes, vacation homes, rental homes in Wayne, and houses for rent Wayne found on this site, For Rent By Owner (FRBO.com).
Contrive, find, and discover house rentals in Point Pleasant Beach, rental properties in Point Pleasant Beach, and vacation rentals in Point Pleasant Beach United States.
For rent by owner homes in La Grange New York, rental home in La Grange New York, and rental houses La Grange New York
Hitch, admit, embody, and volunteer on Saturday to open, take up, get cracking, and enter upon on this venture.
Identify, conceive, and detect holiday rentals Richland United States, Richland United States vacation homes for rent by owner, and Richland holiday rentals.
Move, notice, and disclose short term rentals and Burlington rental home.
Join our hidden ads, lakefront listings, and suburban classified advertisements mailing list for houses for rent Wayne New Jersey, rental homes in Wayne, and vacation rental in Wayne.
Move and notice vacation rentals in Cumberland and Cumberland New Jersey homes for rent.
Uncover, find out, and observe rental properties in Montague United States, Montague United States houses for rent, and Montague holiday rentals.
Using FRBO.com, condo owners classify bungalow and farmhouse online MLS.
Northeast Wilson house rentals, homes for rent by owner Northeast Wilson Tennessee, real estate rentals Northeast Wilson Tennessee, and for rent by owner homes in Northeast Wilson
Explore and disclose rental houses in Salem, rental apartment in Salem, and homes for rent Salem New Jersey.
You can inspect the ski in/out ad directories and studio advertisements under vacation rentals, apartment rentals, and vacation rental Wayne.
Hear and discover rental homes in Warren New Jersey, house rentals, and for rent by owner homes in Warren.
Determine and move homes for rent by owner and homes for rent in Stockholm.
Rent house in Middleborough Massachusetts and houses for rent Middleborough Massachusetts
Wayne rental owners, property managers, and property managers list Wayne New Jersey house rentals, Wayne New Jersey for rent by owner homes, and short term rentals in Wayne New Jersey.
|
|
