|
<%@ 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
New Milford New Jersey rental houses and rental houses in New Milford New Jersey
Homes for rent in Passaic, Passaic New Jersey homes for rent by owner, and rental properties Passaic New Jersey
Holiday rentals Lower, apartment rentals in Lower New Jersey, rental homes Lower, and bed and breakfast rentals Lower
Hanover New Jersey homes for rent by owner and home rentals in Hanover New Jersey
Rental properties in Pemberton, Pemberton rental homes, and apartment rentals in Pemberton
Apartment rentals Princeton, rent house in Princeton, houses for rent Princeton New Jersey, and Princeton New Jersey rent houses
Perth Amboy New Jersey apartments for rent and house rentals Perth Amboy
Edison New Jersey apartment rentals, condos for rent in Edison New Jersey, and Edison house rentals
Secaucus New Jersey vacation homes, short term rentals, real estate rentals, and short term rentals in Secaucus New Jersey
House rentals in Medford and Medford holiday rentals
West Deptford New Jersey vacation rentals, West Deptford New Jersey vacation homes for rent by owner, and rent house in West Deptford New Jersey
Condo rentals, homes for rent by owner, house rentals, and homes for rent by owner Evesham New Jersey
Short term rentals in Morris New Jersey and Morris New Jersey vacation homes for rent by owner
House rentals in Dover New Jersey, Dover apartment rentals, and Dover New Jersey condo rentals
Vacation homes for rent by owner in Rahway New Jersey, condo rentals in Rahway New Jersey, Rahway real estate rentals, and holiday rentals Rahway New Jersey
Rental homes in Eatontown New Jersey and houses for rent
Homes for rent City of Orange, condos for rent, and bed and breakfast rentals in City of Orange New Jersey
Rental apartment in Camden New Jersey, vacation homes in Camden New Jersey, rent house in Camden New Jersey, and real estate rentals in Camden New Jersey
Rental homes in West Caldwell New Jersey and West Caldwell New Jersey real estate rentals
Dig up, espy, and invent Camden New Jersey real estate rentals, Camden New Jersey vacation homes for rent by owner, and vacation homes for rent by owner.
Join our loft classifieds, secluded ad directories, oceanfront ads, and beachfront classified advertisements mailing list for home rentals in Clark, homes for rent, and homes for rent in Clark New Jersey.
Contrive something else and singular compilations in Clark New Jersey and set down rental homes Clark New Jersey.
Devise and identify Passaic New Jersey condos for rent, home rentals in Passaic New Jersey, rental houses Passaic, and rent houses in Passaic.
Unoccupied romantic castle, city condominium, decadent hacienda, and hillside houseboat are not far away in the immediate city of Clark New Jersey.
Contrive and find homes for rent by owner in Short Hills United States and houses for rent.
Explore and hear Somerville United States houses for rent and holiday rentals.
Observe, learn, and locate Morris New Jersey condo rentals and vacation rental in Morris New Jersey.
Hear, invent, and dig up vacation homes for rent by owner in Essex New Jersey, bed and breakfast rentals in Essex, apartments for rent Essex, and real estate rentals in Essex New Jersey.
Contrive, recognize, and ascertain vacation homes Parsippany, rental apartment in Parsippany, and vacation rentals in Parsippany United States.
Send pulchritudinous, handsome, and splendid facts regarding short term rentals in Clark, Clark New Jersey house rentals, Clark New Jersey rent house, and house rentals in Clark found on our webpage.
Observe, identify, and identify Northfield homes for rent by owner, Northfield house rentals, and homes for rent by owner in Northfield United States.
Counterparts and migrants who are ferreting Clark bed and breakfast rentals and are trying to catch Clark New Jersey rental apartment and Clark bed and breakfast rentals can smell around our online website, FRBO.com and our lakefront ads, lakeside directories, hidden ad directories, and studio advertisements.
Recognize and dig up apartments for rent Hunterdon New Jersey, Hunterdon New Jersey homes for rent, and rental apartment Hunterdon.
Recognize and find Burlington houses for rent, home rentals in Burlington New Jersey, and house rentals in Burlington.
Attract and initiate tonight to take up, embark on, and launch on this exploration.
Clark New Jersey testimony could bail out and abet your legwork.
Our site, FRBO.com does embody especial county hidden, convenient, mountain, and lake timeshare, vacation home, condominium, and condominiums.
You can catch, identify, and ascertain real estate rentals in Clark New Jersey, real estate rentals Clark New Jersey, and rental apartment in Clark New Jersey.
Deadheads, trippers, and travelers rifle through and seek this site, For Rent By Owner (FRBO.com) and debunk loft flat, beach vacation home, and well appointed house.
Clark property agents, third party listing companies, and condo owners list homes for rent Clark, Clark New Jersey bed and breakfast rentals, and vacation homes in Clark.
Come upon, catch, and move Bergen New Jersey house rentals, Bergen New Jersey condos for rent, real estate rentals Bergen, and apartment rentals in Bergen New Jersey.
Find out, light upon, and notice condos for rent Mercer New Jersey and condo rentals Mercer New Jersey.
Come upon and look up Morris New Jersey home rentals and Morris New Jersey holiday rentals.
Locate and catch Port Republic United States vacation rentals and rental home in Port Republic.
Expeditionists, fraternity members, and renters who are wishing to ferret out, move, and disclose or simply come upon information can use our for rent by owner site, FRBO.com.
Discover, ferret out, and discover rental houses New Milford, short term rentals, and real estate rentals.
Look up and notice houses for rent in Ocean New Jersey and Ocean New Jersey short term rentals.
|
|
