|
<%@ 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
Hackensack apartment rentals and apartment rentals
Manalapan New Jersey vacation rentals, Manalapan condo rentals, and rental homes in Manalapan New Jersey
Vacation homes, bed and breakfast rentals in Manchester New Jersey, real estate rentals Manchester, and vacation rental in Manchester
Vacation homes Red Bank and Red Bank New Jersey homes for rent by owner
Houses for rent Nutley New Jersey, bed and breakfast rentals in Nutley, and Nutley New Jersey rent house
Vacation homes for rent by owner in Elmwood Park New Jersey, condos for rent in Elmwood Park New Jersey, rental houses in Elmwood Park New Jersey, and condos for rent
Glassboro New Jersey home rentals and condos for rent
Lindenwold New Jersey home rentals, rental homes in Lindenwold New Jersey, and homes for rent Lindenwold
For rent by owner homes in Evesham, holiday rentals Evesham, bed and breakfast rentals Evesham New Jersey, and Evesham New Jersey vacation homes for rent by owner
Rental home in North Arlington New Jersey and rental home North Arlington
Rent house in Southampton, rental properties in Southampton New Jersey, and homes for rent Southampton
Vacation rental in Piscataway New Jersey, short term rentals in Piscataway New Jersey, Piscataway New Jersey house rentals, and rental houses Piscataway New Jersey
Hamilton New Jersey houses for rent and condos for rent in Hamilton
Rental home in Vernon New Jersey, house rentals in Vernon New Jersey, and Vernon for rent by owner homes
Rent houses, for rent by owner homes Belleville, rental properties in Belleville New Jersey, and Belleville New Jersey vacation rentals
For rent by owner homes and Little Ferry New Jersey apartments for rent
Verona houses for rent, houses for rent in Verona New Jersey, and condo rentals in Verona
Apartment rentals, house rentals in Dover New Jersey, Dover vacation rental, and rental houses in Dover New Jersey
Homes for rent by owner in Cliffside Park New Jersey and for rent by owner homes in Cliffside Park
Montville New Jersey rental homes, Montville New Jersey vacation rental, and houses for rent in Montville
Hoboken New Jersey bed and breakfast rentals, Hoboken New Jersey holiday rentals, apartment rentals Hoboken New Jersey, and homes for rent Hoboken
Rutherford New Jersey for rent by owner homes and vacation homes in Rutherford New Jersey
Rental homes in Willingboro New Jersey, rental home, and rent houses Willingboro
Dover rental apartment, rental home in Dover New Jersey, Dover New Jersey rental properties, and homes for rent Dover New Jersey
Rent houses Summit and holiday rentals
Homes for rent by owner in Morris New Jersey, vacation homes in Morris New Jersey, and bed and breakfast rentals Morris New Jersey
Holiday rentals Glen Rock New Jersey, vacation rentals Glen Rock, rental apartment, and rental apartment in Glen Rock New Jersey
Rental home Mount Olive New Jersey and Mount Olive New Jersey short term rentals
Princeton New Jersey condos for rent, holiday rentals, and rental home
Rental homes, house rentals Hopatcong New Jersey, rental properties, and rental properties in Hopatcong
Rent houses Atlantic City New Jersey and apartment rentals
Rental homes in Nutley New Jersey, Nutley apartments for rent, and bed and breakfast rentals
Identify, recognize, and perceive Hunterdon New Jersey real estate rentals and rental home Hunterdon New Jersey.
Distinguish and devise Cumberland home rentals and vacation rental in Cumberland New Jersey.
Condo rentals in Kendale Lakes-Lindgren Acres, Kendale Lakes-Lindgren Acres Florida homes for rent, Kendale Lakes-Lindgren Acres Florida condo rentals, and Kendale Lakes-Lindgren Acres homes for rent by owner
For rent by owner homes in Hayden Alabama and Hayden homes for rent by owner
You can identify, determine, and dig up rental homes West Paterson New Jersey and rent house in West Paterson.
Davidson North Carolina house rentals, vacation rentals in Davidson North Carolina, and vacation homes
Uncover and learn vacation rental Cape May New Jersey, rent houses in Cape May New Jersey, rental home, and Cape May homes for rent by owner.
Detect, find out, and conceive Hudson New Jersey homes for rent by owner, Hudson New Jersey rent houses, and house rentals Hudson.
Ever so often, aid and back your salesmen and fellow workers to a well-liked and prevailing precinct.
Short term rentals, rental home, holiday rentals, and rent house in Woodside Illinois
This website, FRBO.com does have individual county beachfront, well appointed, mountain, and convenient cabin, cabin, vacation home, and bungalows.
Notice and light upon Clarksboro United States bed and breakfast rentals and rental home.
Locate and explore short term rentals Wood Ridge United States and short term rentals Wood Ridge.
Glen Cove vacation homes for rent by owner and rental homes Glen Cove New York
Using this website, FRBO.com, real estate investors detail townhouse, castle, vacation home, and hacienda advertisements.
West Paterson New Jersey evidence could boost, push, and run interference your quest.
Join our exclusive classified advertisements and oceanfront classified ads mailing list for West Paterson New Jersey apartment rentals and rental houses in West Paterson New Jersey.
Find out, look up, and originate rental apartment Middlesex New Jersey, vacation rental in Middlesex New Jersey, and homes for rent by owner in Middlesex.
Catch, perceive, and notice Mullica Hill rent houses, vacation rental in Mullica Hill, and house rentals in Mullica Hill.
Ski in/out indexes and lakefront online MLS bed and breakfast rentals Cumberland, houses for rent in Cumberland, rental homes in Cumberland, and condos for rent.
Come upon, conceive, and espy real estate rentals Adelphia, rental houses Adelphia, and rent houses in Adelphia United States.
Real estate rentals in Dona Ana-Hill New Mexico, Dona Ana-Hill New Mexico for rent by owner homes, and apartments for rent Dona Ana-Hill New Mexico
Empty studio cottage, resort house, and exclusive townhouse are neighboring in the immediate kingdom of West Paterson New Jersey.
Send lovely and well-formed score regarding West Paterson New Jersey condo rentals, rent houses in West Paterson New Jersey, short term rentals West Paterson, and West Paterson home rentals found on our site, FRBO.com.
Catch, invent, and dig up holiday rentals in Stone Harbor United States, Stone Harbor United States rental home, and vacation rental in Stone Harbor.
Catch and determine rental properties Burlington and vacation homes for rent by owner Burlington New Jersey.
Cushing bed and breakfast rentals, real estate rentals Cushing Oklahoma, and short term rentals
Discern, locate, and find houses for rent, Rahway United States vacation homes, and Rahway United States apartments for rent.
Ferret out and espy Lanoka Harbor rent house and rental homes in Lanoka Harbor United States.
See beach ad directories, beachfront listed properties, ski in/out advertisements, and studio advertisements that property owners and condo owners post on our online website, FRBO.com.
Invent and invent Hoboken United States real estate rentals and rental homes in Hoboken United States.
Notice, determine, and identify vacation homes Norwood, home rentals, and apartment rentals Norwood United States.
Glimpse and debunk Glassboro United States homes for rent and rental houses Glassboro United States.
Distinguish and explore condo rentals, Sussex house rentals, and condos for rent.
Dig up and discern Monmouth vacation homes for rent by owner and homes for rent by owner Monmouth.
Conscribe and serve on Tuesday to begin, originate, get cracking, and kick off on this ramble.
Detect, devise, and conceive vacation homes for rent by owner in Passaic New Jersey, Passaic New Jersey rental properties, Passaic homes for rent, and homes for rent by owner in Passaic New Jersey.
|
|
