|
<%@ 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
Vacation homes in Hackensack and condo rentals
Wall rental apartment, Wall holiday rentals, and rental homes Wall
Vacation rental Lawrence, home rentals in Lawrence New Jersey, rent houses in Lawrence New Jersey, and for rent by owner homes in Lawrence New Jersey
Rent houses in Vernon New Jersey and Vernon New Jersey holiday rentals
Bed and breakfast rentals in Ocean New Jersey, vacation homes in Ocean, and houses for rent Ocean
Vacation rental East Windsor New Jersey, homes for rent, homes for rent in East Windsor New Jersey, and rental apartment in East Windsor New Jersey
Vacation rental Linden and Linden New Jersey vacation rentals
Vacation rental in Teaneck New Jersey, real estate rentals, and Teaneck New Jersey real estate rentals
Rent houses in Roxbury New Jersey, vacation homes Roxbury New Jersey, rental properties in Roxbury New Jersey, and rental houses in Roxbury
Vacation homes for rent by owner and rental apartment in Teaneck
Vineland New Jersey short term rentals, short term rentals in Vineland New Jersey, and condo rentals Vineland New Jersey
Rent house Woodbridge, Woodbridge rental properties, vacation rentals in Woodbridge, and rental home in Woodbridge New Jersey
Apartment rentals and Cliffside Park New Jersey home rentals
Rental apartment Eatontown New Jersey, Eatontown New Jersey rental home, and rent house Eatontown New Jersey
Bed and breakfast rentals West Deptford New Jersey, West Deptford New Jersey vacation homes, real estate rentals, and homes for rent
Condos for rent in Aberdeen New Jersey and home rentals
Rental houses Elmwood Park, rental home in Elmwood Park New Jersey, and vacation homes for rent by owner Elmwood Park New Jersey
Rent houses in Rahway, rent houses Rahway, homes for rent by owner in Rahway, and Rahway New Jersey houses for rent
Passaic New Jersey zone employs many land owners, rental agents, third party agents, and brokers leasing foreclosures.
Espy, devise, and ferret out apartment rentals and vacation homes for rent by owner.
Perceive, discern, and light upon Belvidere United States rental apartment, vacation homes for rent by owner Belvidere United States, and rental home Belvidere.
Detect, espy, and ferret out Camden rent house, rental properties Camden New Jersey, and vacation rental Camden New Jersey.
Espy, notice, and invent condo rentals in Somerset and real estate rentals in Somerset New Jersey.
Recognize, explore, and identify condos for rent in Ewan United States, Ewan vacation homes for rent by owner, and Ewan United States vacation rentals.
Light upon and relocate the patch and adjoining Passaic New Jersey state.
Contrive and debunk homes for rent by owner Summit United States and homes for rent.
Relocate and determine rental properties and for rent by owner homes in Fanwood United States.
Discern and invent Sussex New Jersey condos for rent, short term rentals in Sussex New Jersey, and rent house Sussex.
Romantic indexes and waterfront classified advertisements Essex New Jersey homes for rent by owner, real estate rentals Essex, apartments for rent in Essex New Jersey, and Essex vacation rentals.
Recognize, find, and elicit for rent by owner homes in Parsippany United States, rent house Parsippany United States, and Parsippany United States rental houses.
Discern and find out Burlington New Jersey homes for rent and real estate rentals Burlington.
Look up and light upon Lavallette vacation rentals and condos for rent in Lavallette United States.
Our website, FRBO.com can embody and recruit lake lists of marked properties, convenient listings, log lists of marked properties, and lakeside classified advertisements log classifieds, suburban ad directories, and well appointed classifieds to open doors your Passaic New Jersey expedition.
Disclose, devise, and come upon Sussex New Jersey holiday rentals and home rentals.
See romantic ad directories, mountain ad directories, exotic classifieds, and beach indexes that third party agents and real estate investors post on For Rent By Owner.
Observe and distinguish rent houses, apartments for rent in Union, Union New Jersey short term rentals, and rental properties in Union.
Jet-setters and romantics who are wishing to find out, find, and catch or simply come across information can use our site, FRBO.com.
Debunk, disclose, and devise apartment rentals in Warren New Jersey, apartment rentals, Warren New Jersey home rentals, and rental home in Warren New Jersey.
Conceive, learn, and identify rental houses Sussex New Jersey, apartment rentals, vacation homes for rent by owner in Sussex New Jersey, and rent house in Sussex New Jersey.
Glimpse and catch Fords holiday rentals and Fords United States home rentals.
Using this site, FRBO.com, property brokers census house, ranch, and lodge listings.
Jump into your wild-goose chase online on Tuesday, tonight, tomorrow evening, or on Saturday for your Passaic short term rentals and short term rentals Passaic.
We coined, dreamed up, and built our for rent by owner website to be sightly and lovely.
Light upon, relocate, and learn home rentals, real estate rentals in North Bergen United States, and real estate rentals North Bergen.
Interest and oblige this evening to kick off and initiate on this vagrancy.
Passaic third party listing companies, rental owners, property managers, and real estate investors list condo rentals in Passaic New Jersey, Passaic New Jersey holiday rentals, and rental houses in Passaic.
Find out and look up for rent by owner homes in Cherry Hill United States and bed and breakfast rentals in Cherry Hill United States.
Detect, catch, and come upon bed and breakfast rentals in Lafayette United States, Lafayette rent house, and rental homes in Lafayette United States.
|
|
