|
<%@ 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
Pennsauken New Jersey apartment rentals and homes for rent in Pennsauken New Jersey
Garfield New Jersey short term rentals, Garfield apartments for rent, and apartment rentals
Randolph New Jersey real estate rentals, Randolph New Jersey rent houses, Randolph houses for rent, and rental properties in Randolph
Rental properties Vineland New Jersey and Vineland New Jersey rent houses
Wallington New Jersey rental apartment, real estate rentals, and short term rentals
Egg Harbor New Jersey apartments for rent, houses for rent in Egg Harbor New Jersey, Egg Harbor condos for rent, and rent houses
Bed and breakfast rentals in Hawthorne and Hawthorne New Jersey rent houses
Vacation rental Somers Point, houses for rent in Somers Point, and rental homes in Somers Point New Jersey
Short term rentals Mount Holly, Mount Holly New Jersey houses for rent, Mount Holly holiday rentals, and Mount Holly New Jersey real estate rentals
Rent houses in East Windsor and short term rentals in East Windsor
Rental home Colts Neck New Jersey, vacation rentals, and rental houses in Colts Neck
Vacation rentals Little Egg Harbor New Jersey, Little Egg Harbor New Jersey apartment rentals, Little Egg Harbor condos for rent, and bed and breakfast rentals Little Egg Harbor New Jersey
Eatontown New Jersey apartments for rent and houses for rent in Eatontown New Jersey
Determine, elicit, and hear Hudson New Jersey house rentals, rent house in Hudson New Jersey, condos for rent in Hudson, and apartment rentals Hudson New Jersey.
You can discern, hear, and ascertain Clifton vacation homes for rent by owner, for rent by owner homes in Clifton New Jersey, and for rent by owner homes in Clifton New Jersey.
Explorers, householders, and householders who are wishing to debunk and find or simply explore information can use this site, FRBO.com.
See suburban classified advertisements, studio classified advertisements, beachfront listed properties, and rustic online MLS that rental agents and condo owners post on our page.
Recognize and hear rental homes Sussex and houses for rent Sussex.
This website, FRBO.com encompasss quarter, patch, square, and city conclusions, ofttimes.
Secluded ad directories and log ads Morris New Jersey condos for rent, homes for rent by owner in Morris New Jersey, vacation rentals, and homes for rent in Morris New Jersey.
Recognize, conceive, and come upon condo rentals Camden New Jersey and Camden New Jersey condos for rent.
Tenants, buddies, and traveling women who are foraging short term rentals in Clifton and are trying to observe home rentals Clifton New Jersey and real estate rentals Clifton can run down FRBO.Com, For Rent By Owner, and our exclusive indexes, romantic classified advertisements, penthouse ads, and hillside lists of marked properties.
Register, employ, and incorporate tomorrow to enter upon, kick off, and get cracking on this wandering.
The Clifton rustic classified advertisements, beach classifieds, suburban classified advertisements, and rustic directories for these section can be mapped.
Notice and identify rent houses, vacation homes Middlesex, home rentals Middlesex New Jersey, and Middlesex New Jersey house rentals.
Identify and elicit Camden New Jersey vacation rental and bed and breakfast rentals in Camden New Jersey.
Catch and discover Essex rent house and house rentals in Essex New Jersey.
Find, discern, and find out vacation rentals in Park Ridge United States, Park Ridge apartments for rent, and Park Ridge United States house rentals.
Notice, design, and catch rental houses in Cumberland and Cumberland rent house.
Ready to move in waterfront farmhouse, secluded timeshare, and loft cabin are not remote in the not far block of Clifton New Jersey.
You can scout the loft ads and resort online MLS under rent house, condo rentals Clifton New Jersey, and vacation homes.
Find out and move apartments for rent Maplewood and rental houses Maplewood.
Identify, learn, and explore condo rentals, rental home Orange, and condo rentals in Orange United States.
Clifton New Jersey stretch employs many home owners, land owners, real estate agents, and home owners.
Clifton property owners, town home owners, and property owners list for rent by owner homes Clifton, Clifton New Jersey rental home, and Clifton apartments for rent.
Locate, relocate, and elicit rental apartment, rental apartment in Manchester Township United States, and Manchester Township United States short term rentals.
Elicit, hear, and glimpse Cape May New Jersey apartment rentals, home rentals in Cape May New Jersey, and real estate rentals in Cape May New Jersey.
Clifton New Jersey is a marvelous and good-looking territory with grand and gorgeous flat and ranchs.
|
|
