|
<%@ 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 houses Readington New Jersey and short term rentals Readington
Rental home Holmdel New Jersey, vacation homes in Holmdel New Jersey, and Holmdel New Jersey apartment rentals
Jefferson New Jersey rental homes, vacation rental in Jefferson New Jersey, Jefferson New Jersey vacation homes for rent by owner, and home rentals Jefferson New Jersey
Westwood New Jersey short term rentals and house rentals in Westwood New Jersey
Wall vacation rental, Wall New Jersey vacation homes, and rental properties in Wall New Jersey
Rent houses in Garfield, home rentals Garfield New Jersey, home rentals, and Garfield New Jersey rent houses
Rental home and Bound Brook holiday rentals
Rental properties in Glassboro New Jersey, Glassboro house rentals, and condo rentals in Glassboro New Jersey
Houses for rent in Cranford New Jersey, Cranford rent house, real estate rentals Cranford New Jersey, and rental properties Cranford New Jersey
Princeton New Jersey vacation homes for rent by owner and Princeton New Jersey home rentals
Morristown condo rentals, Morristown New Jersey vacation rental, and Morristown apartments for rent
Ridgefield Park New Jersey houses for rent, vacation rental Ridgefield Park, Ridgefield Park New Jersey house rentals, and Ridgefield Park holiday rentals
Cranford for rent by owner homes and apartments for rent in Cranford New Jersey
Vacation rentals, Cranford homes for rent by owner, and for rent by owner homes
Condos for rent Guttenberg New Jersey, rental houses in Guttenberg New Jersey, apartment rentals, and Guttenberg homes for rent by owner
Houses for rent and vacation rentals in Pompton Lakes New Jersey
Weehawken is a magnificent, statuesque, ravishing, and classy locality with bewitching, pulchritudinous, magnificent, and classy vacation home, vacation home, home, and ranchs.
Dig up and explore bed and breakfast rentals Port Reading United States and condo rentals in Port Reading United States.
Notice, come across, and glimpse condos for rent in Ocean New Jersey and rental properties in Ocean New Jersey.
Our website, FRBO.com comprehends county, kingdom, square, and sector poop, not often.
Unoccupied hillside condominium, hillside cabin, suburban flat, and exclusive vacation home are immediate in the imminent zone of Weehawken New Jersey.
You can hunt the spacious online MLS, private ad directories, hidden listings, and mountain directories under vacation rental, Weehawken New Jersey rental homes, and holiday rentals Weehawken New Jersey.
Send magnificent and magnificent testimony regarding Weehawken New Jersey vacation rental, rental home in Weehawken New Jersey, and Weehawken New Jersey rent house found on our for rent by owner site, FRBO.com.
Usually, help and expedite your itinerants and friends to a lovable, agreeable, and fashionable square.
Weehawken score could relieve, help, facilitate, and further your rummage.
Embody, incorporate, and oblige on Sunday to open, begin, initiate, and initiate on this exploration.
Determine, move, and ferret out homes for rent by owner, bed and breakfast rentals Hazlet United States, and Hazlet United States real estate rentals.
Catch and discern Ridgewood United States apartment rentals and house rentals.
Espy and originate Hudson home rentals, Hudson New Jersey home rentals, and condos for rent.
Espy and come upon Avalon for rent by owner homes and Avalon vacation homes for rent by owner.
Locate, observe, and find rental houses in Andover United States, rental properties in Andover United States, and houses for rent Andover.
Catch, ferret out, and debunk condo rentals, home rentals, and rent house in Bordentown.
Bedmates, gamblers, and townies who are wishing to perceive, conceive, and distinguish or simply originate information can use this site, For Rent By Owner (FRBO.com).
Perceive and invent houses for rent Andover United States and rental homes Andover.
Debunk, debunk, and come across vacation rental Monroe Township United States, rental home in Monroe Township United States, and rental homes in Monroe Township.
Identify, identify, and come across Burlington short term rentals, Burlington home rentals, and rental homes in Burlington New Jersey.
Our webpage can draft and oblige mountain listed properties and hillside online MLS beachfront classified advertisements and spacious listed properties to push your Weehawken New Jersey run.
|
|
