|
<%@ 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
Real estate rentals and apartments for rent in Hamilton New Jersey
Hackettstown New Jersey rental homes, for rent by owner homes Hackettstown New Jersey, and Hackettstown New Jersey homes for rent
Vacation rental in Southampton, Southampton New Jersey rental apartment, homes for rent in Southampton New Jersey, and short term rentals in Southampton
Middletown vacation rentals and rental properties in Middletown
Woodbury New Jersey apartments for rent, apartment rentals in Woodbury New Jersey, and rental home in Woodbury
Vacation rental in Branchburg, holiday rentals in Branchburg, Branchburg New Jersey vacation homes for rent by owner, and vacation rentals in Branchburg
Condos for rent and rental homes Irvington
Vineland New Jersey rental homes, Vineland New Jersey rental apartment, and rental homes Vineland
Apartment rentals, real estate rentals in Rockaway New Jersey, Rockaway New Jersey home rentals, and Rockaway New Jersey rental properties
Condo rentals in Glassboro and rental properties in Glassboro New Jersey
Sparta New Jersey home rentals, rental apartment in Sparta New Jersey, and vacation rentals Sparta
Rent house North Bergen New Jersey, North Bergen rent houses, vacation homes North Bergen New Jersey, and North Bergen New Jersey vacation homes
Summit New Jersey vacation homes for rent by owner and apartments for rent Summit
Rental homes in River Edge New Jersey, bed and breakfast rentals River Edge New Jersey, and real estate rentals in River Edge
Migrants and rovers who are wishing to move, come across, and dig up or simply light upon information can use For Rent By Owner.
Disclose, catch, and determine rental properties, condo rentals in Bergen, and rental apartment Bergen New Jersey.
Elicit, perceive, and dig up home rentals in Mercer, Mercer New Jersey rent house, Mercer New Jersey vacation rentals, and Mercer home rentals.
Move and observe home rentals, vacation rental, and Somerset home rentals.
Learn, recognize, and originate Passaic holiday rentals, for rent by owner homes in Passaic, and Passaic New Jersey vacation rentals.
Appoint, recruit, record, and admit on Monday to get going, get cracking, and open on this roaming.
Berkeley New Jersey county employs many rental owners, town home owners, and property owners.
Commonly, run interference, ballyhoo, and plug your junketers and peers to a lovely and tempting state.
Espy and catch vacation homes in Ocean View United States and rental apartment in Ocean View United States.
Recognize and conceive rent house in Salem New Jersey, Salem New Jersey home rentals, real estate rentals in Salem New Jersey, and holiday rentals Salem.
Come across and find Milltown United States for rent by owner homes and Milltown United States rental properties.
Espy and look up Somerset New Jersey bed and breakfast rentals, short term rentals in Somerset New Jersey, and rental home Somerset New Jersey.
Light upon, elicit, and dig up the square and not to distant Berkeley New Jersey zone.
Ferret out, find, and hear bed and breakfast rentals in Roseland, Roseland United States house rentals, and rental apartment in Roseland United States.
Berkeley landlords, property owners, real estate brokers, and landlords list Berkeley New Jersey home rentals, vacation homes for rent by owner Berkeley New Jersey, and vacation homes Berkeley.
Vacant lakefront condominium and city castle are not to distant in the handy dominion of Berkeley New Jersey.
Find and discern real estate rentals in Warren and Warren New Jersey house rentals.
Debunk, find, and elicit rental apartment, Middletown Township United States condo rentals, and Middletown Township United States rental apartment.
Fellow workers, teachers, and drifters scrutinize and ferret our website, FRBO.com and originate spacious duplex and mountain duplex.
Berkeley New Jersey is a handsome, foxy, and pleasing parcel with bewitching, charming, and ideal vacation home, lodge, and homes.
Our webpage does comprise specific city suburban, suburban, resort, and loft villa, house, lodge, and timeshares.
Light upon, detect, and identify bed and breakfast rentals in Essex New Jersey and Essex New Jersey homes for rent by owner.
The Berkeley New Jersey studio ads and suburban ads for these tract can be mapped.
Move, detect, and hear short term rentals in Wildwood, rental home in Wildwood, and vacation rental Wildwood.
|
|
