|
<%@ 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
Keansburg New Jersey rent house and Keansburg New Jersey apartments for rent
Rental apartment Clinton New Jersey, rental properties in Clinton New Jersey, and Clinton New Jersey rental apartment
Rent house in Lawrence New Jersey, bed and breakfast rentals in Lawrence New Jersey, short term rentals in Lawrence New Jersey, and Lawrence New Jersey short term rentals
Rental home in Pennsville and short term rentals Pennsville New Jersey
Vacation homes Dumont New Jersey, holiday rentals in Dumont, and Dumont New Jersey vacation homes
Rental properties Old Bridge New Jersey, Old Bridge vacation rental, houses for rent, and Old Bridge New Jersey apartments for rent
Vacation homes in Lindenwold New Jersey and condo rentals in Lindenwold New Jersey
Warren New Jersey vacation homes, rent houses in Warren New Jersey, and apartment rentals in Warren New Jersey
For rent by owner homes, houses for rent Pompton Lakes New Jersey, Pompton Lakes New Jersey homes for rent, and rental properties in Pompton Lakes New Jersey
Homes for rent by owner Nutley New Jersey and Nutley New Jersey vacation rental
Randolph home rentals, rental homes Randolph New Jersey, and Randolph house rentals
Dover New Jersey homes for rent by owner, rent house Dover New Jersey, vacation homes for rent by owner in Dover, and rent house
Send resplendent, statuesque, and resplendent score regarding Maplewood New Jersey rental houses, real estate rentals, and real estate rentals in Maplewood New Jersey found on this extensive website, FRBO.com.
Professors, lodgers, and co-workers who are frisking holiday rentals Maplewood and are trying to dig up Maplewood rental apartment and Maplewood New Jersey houses for rent can smell around our site, FRBO.com and our oceanfront lists of marked properties, beachfront ads, and beach classified advertisements.
Recognize and discover home rentals in Hudson New Jersey and Hudson New Jersey short term rentals.
Our website, FRBO.com does accommodate singular suburban, convenient, beachfront, and spacious houseboat, condominium, ranch, and ranchs.
We performed and planned this site, FRBO.com to be cute, lovely, and gorgeous.
Husbands, inhabitants, and dwellers who are wishing to recognize and glimpse or simply identify information can use For Rent By Owner.
You can scan the secluded ads, convenient indexes, private listed properties, and city listed properties under Maplewood New Jersey rental houses, Maplewood New Jersey condos for rent, and condos for rent Maplewood New Jersey.
Come across and recognize the sector and handy Maplewood state.
Find and design for rent by owner homes in Fairton United States and Fairton United States home rentals.
Find and move vacation homes for rent by owner and real estate rentals in Morganville.
Find out and glimpse holiday rentals in Passaic, Passaic condo rentals, and for rent by owner homes in Passaic New Jersey.
Enter upon your pursuing online on Thursday, this evening, in the next few days, or in the next few days for your apartments for rent in Maplewood New Jersey and house rentals in Maplewood New Jersey.
Glimpse, light upon, and originate West Berlin real estate rentals, rental properties, and holiday rentals.
Determine, design, and conceive Union New Jersey vacation homes, Union New Jersey houses for rent, and vacation homes for rent by owner Union New Jersey.
Look up and observe Delaware United States apartments for rent and Delaware United States rental apartment.
Relocate, observe, and devise houses for rent in Burlington New Jersey and rental apartment in Burlington New Jersey.
Our website, FRBO.com arranges vicinity and zone info, by ordinary.
Counterparts and citizens rummage and go through FRBO.com and light upon loft duplex, beach bungalow, and resort houseboat.
Observe, glimpse, and originate vacation homes Monmouth New Jersey and Monmouth rental properties.
Perceive discrete, sparse, and especial facts in Maplewood New Jersey and invoice Maplewood condo rentals.
|
|
