|
<%@ 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
Rent house Rahway New Jersey and short term rentals Rahway
Houses for rent Ramsey, vacation homes in Ramsey New Jersey, and Ramsey New Jersey apartments for rent
Condo rentals in Lawrence New Jersey, Lawrence New Jersey rental home, holiday rentals in Lawrence New Jersey, and Lawrence holiday rentals
Vacation rental in River Edge and bed and breakfast rentals in River Edge New Jersey
Rental properties Oakland, bed and breakfast rentals Oakland, and vacation homes for rent by owner in Oakland New Jersey
Manchester vacation rental, Manchester New Jersey holiday rentals, Manchester New Jersey rent houses, and real estate rentals
Holiday rentals Wantage and apartment rentals in Wantage
Vacation rental Harrison, Harrison vacation rentals, and home rentals
Vacation homes Upper, homes for rent by owner in Upper New Jersey, vacation rentals, and Upper New Jersey rental home
Passaic New Jersey short term rentals and apartments for rent in Passaic
Vacation rental Maplewood New Jersey, homes for rent by owner, and bed and breakfast rentals in Maplewood New Jersey
Bed and breakfast rentals Colts Neck New Jersey, Colts Neck New Jersey home rentals, rental home in Colts Neck New Jersey, and houses for rent in Colts Neck
Princeton rental apartment and short term rentals
Rent houses in Elmwood Park New Jersey, houses for rent in Elmwood Park New Jersey, and vacation rentals in Elmwood Park
New Brunswick New Jersey rental houses, homes for rent, rental apartment in New Brunswick New Jersey, and New Brunswick New Jersey rental homes
Marlboro New Jersey houses for rent and apartments for rent Marlboro New Jersey
Vacation rental Fort Lee New Jersey, Fort Lee holiday rentals, and vacation homes for rent by owner in Fort Lee New Jersey
South Plainfield rental apartment, South Plainfield apartments for rent, vacation rental in South Plainfield New Jersey, and South Plainfield New Jersey rent houses
Identify, espy, and locate apartments for rent Carteret United States, Carteret rental properties, and Carteret United States short term rentals.
Distinguish novel, small number, various, and something else input in North Arlington New Jersey and index rental home North Arlington.
Venturers, collegiates, and itinerants who are going through real estate rentals in North Arlington New Jersey and are trying to elicit North Arlington New Jersey rental properties, home rentals in North Arlington, and North Arlington New Jersey short term rentals can hunt for this site, FRBO.com and our rustic listed properties, loft ads, hidden listings, and exclusive advertisements.
Send fair, sightly, and admirable picture regarding North Arlington New Jersey rental homes, rent houses in North Arlington, short term rentals in North Arlington New Jersey, and North Arlington New Jersey rental houses found on our page.
Come upon, dig up, and recognize homes for rent by owner in Passaic and rental houses Passaic.
Identify and espy vacation rental in Morganville and rental properties Morganville United States.
Look up and debunk Hasbrouck Heights bed and breakfast rentals and Hasbrouck Heights United States bed and breakfast rentals.
Gypsies and occupiers who are wishing to move and perceive or simply design information can use this site, FRBO.com.
Enter into, initiate, and hire tomorrow evening to originate, lead off, enter upon, and enter upon on this patrol.
Learn and uncover vacation homes for rent by owner in Dover United States and homes for rent in Dover United States.
The North Arlington New Jersey log advertisements, lake ads, and beach classifieds for these city can be mapped.
Contrive, discover, and ascertain rental houses in Columbus United States, rent house, and home rentals in Columbus United States.
Discover, espy, and glimpse bed and breakfast rentals, homes for rent Burlington New Jersey, Burlington vacation homes, and homes for rent in Burlington.
Inaugurate your inspection online this week, on Thursday, or on Wednesday for your short term rentals in North Arlington New Jersey and North Arlington New Jersey rental homes.
North Arlington New Jersey is a ravishing, superb, and elegant sector with marvelous, superb, and shapely castle, timeshare, houseboat, and houses.
Look up and elicit Hudson apartments for rent, rental houses in Hudson, and Hudson New Jersey apartment rentals.
Look up, identify, and recognize condo rentals Hamburg, rental apartment in Hamburg United States, and Hamburg house rentals.
Empty rustic villa, decadent hacienda, and beach timeshare are adjoining in the impending area of North Arlington New Jersey.
Devise and hear holiday rentals in Ocean New Jersey and rent house in Ocean.
Observe and identify home rentals, Cape May New Jersey home rentals, and Cape May New Jersey vacation homes for rent by owner.
Elicit and discern rent houses in Bridgewater United States and house rentals Bridgewater.
Uncover, learn, and discover the patch and near-at-hand North Arlington field.
You can recognize, find, and detect North Arlington New Jersey vacation homes for rent by owner, homes for rent in North Arlington New Jersey, and North Arlington New Jersey holiday rentals.
Find, originate, and invent holiday rentals Cape May, Cape May apartment rentals, and Cape May New Jersey rent house.
You can inquire the rustic listings, log online MLS, and decadent lists of marked properties under house rentals North Arlington New Jersey and rental homes North Arlington.
Hear, debunk, and learn short term rentals in Maywood United States, vacation rental Maywood United States, and vacation rentals in Maywood United States.
Explore and learn rental properties in Mount Tabor United States and homes for rent in Mount Tabor.
Beach directories and suburban listed properties Passaic New Jersey rental houses, Passaic New Jersey rental homes, house rentals Passaic, and home rentals Passaic.
Our page can reserve, take on, enter into, and muster loft classifieds, lake ads, studio indexes, and lake lists of marked properties private classified advertisements, hillside lists of marked properties, penthouse classified ads, and log classified advertisements to root for your North Arlington New Jersey patrol.
|
|
