|
<%@ 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
Holiday rentals in Hawthorne and Hawthorne New Jersey bed and breakfast rentals
Houses for rent, rental home Clinton New Jersey, and condo rentals in Clinton
Rental homes Morris New Jersey, Morris New Jersey homes for rent, Morris rental houses, and Morris New Jersey vacation homes
Rent house in Middle New Jersey and Middle New Jersey rental houses
Franklin New Jersey homes for rent by owner, rent houses in Franklin, and Franklin New Jersey homes for rent
Bed and breakfast rentals Hackettstown, short term rentals, condo rentals in Hackettstown New Jersey, and vacation rental in Hackettstown New Jersey
Holiday rentals in Wantage and Wantage vacation rental
Mount Olive vacation rental, rent houses in Mount Olive New Jersey, and bed and breakfast rentals Mount Olive
Holiday rentals in Southampton, houses for rent Southampton New Jersey, condo rentals in Southampton New Jersey, and homes for rent by owner
Rental properties in Kearny and house rentals in Kearny
Bed and breakfast rentals in South River New Jersey, houses for rent in South River New Jersey, and holiday rentals
Rental apartment South Orange Village, South Orange Village New Jersey condos for rent, homes for rent by owner in South Orange Village New Jersey, and South Orange Village New Jersey apartment rentals
Houses for rent Fort Lee New Jersey and rental properties Fort Lee New Jersey
Condos for rent in Montclair New Jersey, rent house in Montclair, and apartment rentals in Montclair New Jersey
Lawrence New Jersey rental properties, Lawrence rental homes, Lawrence New Jersey rental apartment, and vacation rentals
Rent house and Long Branch short term rentals
Pleasantville New Jersey vacation rentals, real estate rentals in Pleasantville New Jersey, and condo rentals Pleasantville
For rent by owner homes, condos for rent in Kearny, real estate rentals in Kearny, and rental home in Kearny New Jersey
Lumberton New Jersey rental homes and vacation homes for rent by owner Lumberton New Jersey
Short term rentals in Marlboro New Jersey, rent house in Marlboro, and bed and breakfast rentals in Marlboro
Hanover houses for rent, house rentals in Hanover New Jersey, condo rentals in Hanover, and Hanover New Jersey apartment rentals
Manchester rent houses and vacation homes for rent by owner
Upper New Jersey home rentals, houses for rent, and Upper New Jersey rental homes
Roselle New Jersey homes for rent, homes for rent in Roselle New Jersey, Roselle New Jersey rental apartment, and Roselle New Jersey for rent by owner homes
Rental home Paterson New Jersey and vacation rentals in Paterson New Jersey
Rental home in Brigantine New Jersey, vacation homes for rent by owner in Brigantine New Jersey, and short term rentals
Barnegat New Jersey real estate rentals, house rentals Barnegat, rental houses in Barnegat New Jersey, and apartment rentals
Short term rentals in Burlington New Jersey and vacation rentals
Rockaway New Jersey real estate rentals, houses for rent Rockaway, and vacation homes for rent by owner in Rockaway New Jersey
Rental houses in Brick, vacation homes in Brick New Jersey, real estate rentals in Brick New Jersey, and rent house in Brick
For rent by owner homes in Summit New Jersey and rental homes
Rent houses Englewood, rent house Englewood New Jersey, and rental properties in Englewood
Princeton New Jersey vacation rental and real estate rentals in Princeton New Jersey
Determine, move, and uncover vacation rentals Middlesex, vacation homes for rent by owner in Middlesex, and bed and breakfast rentals.
Norman Oklahoma apartments for rent, Norman Oklahoma rent house, vacation rental in Norman Oklahoma, and apartment rentals in Norman Oklahoma
Learn and notice East Rutherford United States rental homes and rental home in East Rutherford United States.
Conceive, espy, and ascertain Colonia United States vacation rentals, Colonia United States home rentals, and holiday rentals in Colonia.
FRBO.com encloses patch, domain, and state dossier, by ordinary.
Trenton New Jersey section employs many third party listing companies, agents, rental property owners, and real estate brokers.
Catch and detect Grenloch United States short term rentals and Grenloch vacation rental.
Uncover, disclose, and come upon condos for rent, Belmar vacation homes, and holiday rentals Belmar.
Uncover and relocate short term rentals in Hunterdon and Hunterdon New Jersey homes for rent.
Send lovely, ravishing, and grand facts regarding rental houses in Trenton New Jersey, short term rentals, apartment rentals in Trenton, and Trenton New Jersey condo rentals found on FRBO.com.
Wanderers, traveling men, and bedmates who are wishing to look up, conceive, and identify or simply hear information can use this website, FRBO.com.
Apartment rentals Robertsdale, vacation homes in Robertsdale, Robertsdale vacation homes for rent by owner, and vacation rental in Robertsdale
Roomers and fraternity members who are running down for rent by owner homes in Trenton New Jersey and are trying to learn rental houses in Trenton New Jersey and Trenton New Jersey for rent by owner homes can beat about our page and our beach ad directories, convenient classified advertisements, decadent classified ads, and hidden online MLS.
FRBO.com can employ and reserve well appointed lists of marked properties, waterfront listings, resort directories, and romantic classified ads city directories, hillside listings, resort ad directories, and lakefront ad directories to plug your Trenton New Jersey outing.
Rental homes in La Fayette, houses for rent La Fayette, and vacation rentals
Design and design Cumberland house rentals and Cumberland vacation rental.
Come upon, move, and debunk Middlesex New Jersey houses for rent, for rent by owner homes in Middlesex New Jersey, and short term rentals Middlesex New Jersey.
Identify and ascertain real estate rentals in Somerset New Jersey, condo rentals Somerset New Jersey, homes for rent by owner Somerset, and rental home Somerset.
Trenton goods could aid, open doors, run interference, and hype your inquest.
Catch, determine, and espy short term rentals in Pequannock, rental properties Pequannock, and for rent by owner homes Pequannock.
Perceive, determine, and perceive rental properties Somerset, Somerset New Jersey real estate rentals, Somerset New Jersey rental houses, and rental apartment.
Move and discern vacation rental Dunellen and condos for rent Dunellen United States.
Distinguish, contrive, and catch homes for rent Wickatunk United States, rental properties in Wickatunk United States, and Wickatunk United States rental houses.
Trenton landlords and property managers list short term rentals Trenton New Jersey, holiday rentals, Trenton New Jersey rental properties, and Trenton New Jersey houses for rent.
Determine and detect homes for rent in Cape May and rent houses in Cape May.
FRBO.com does embrace especial block private, decadent, exclusive, and studio ranch, duplex, hacienda, and ranchs.
Procure, assign, and secure now to get cracking, launch, kick off, and initiate on this traverse.
Invent, come upon, and conceive rental houses Mercer, vacation rentals in Mercer, and Mercer house rentals.
Lompoc Valley California vacation rental, rental homes in Lompoc Valley California, vacation homes Lompoc Valley California, and Lompoc Valley California bed and breakfast rentals
Ascertain, determine, and invent Barrington rental home, houses for rent in Barrington United States, and home rentals in Barrington.
You can perceive, find, and originate Trenton apartment rentals, vacation rental in Trenton New Jersey, and home rentals in Trenton New Jersey.
Explore and espy rental home in Somerset, rental properties in Somerset New Jersey, and homes for rent.
Catch and come upon homes for rent by owner, rent house in Hudson, Hudson New Jersey rent houses, and Hudson New Jersey apartments for rent.
Espy and detect condos for rent in Pine Hill United States and homes for rent in Pine Hill.
Plum Pennsylvania rental home, rental home in Plum Pennsylvania, Plum Pennsylvania holiday rentals, and homes for rent Plum Pennsylvania
Elicit and learn home rentals in Morganville United States and rent houses in Morganville.
Devise, detect, and find out rental homes Maple Shade, Maple Shade United States rental home, and vacation homes in Maple Shade United States.
We occasioned, produced, and organized our for rent by owner website to be ravishing, well-formed, comely, and beauteous.
Soon to be vacant beach ranch and hillside townhouse are nearby in the not far away field of Trenton.
Detect, dig up, and locate apartment rentals Essex New Jersey, Essex rent house, and rental home Essex New Jersey.
Periodically, stump, reinforce, serve, and boost your sisters, indwellers, and comrades to a promoted and capacious locality.
Patton Pennsylvania vacation homes, apartment rentals Patton Pennsylvania, and Patton Pennsylvania rental properties
Renters, sailors, and habitants hunt for and look over our site, FRBO.com and perceive waterfront townhouse, private castle, and ski in/out ranch.
Invent and detect Hasbrouck Heights rent house and apartment rentals in Hasbrouck Heights United States.
You can go through the resort listed properties and private advertisements under for rent by owner homes Trenton New Jersey and condo rentals in Trenton New Jersey.
See lakeside classified advertisements, loft online MLS, hidden listed properties, and lakefront advertisements that land owners and third party listing companies post on our website, FRBO.com.
Relocate, uncover, and originate homes for rent in Hunterdon and holiday rentals in Hunterdon New Jersey.
Explore and identify vacation rental Pedricktown United States and houses for rent Pedricktown.
|
|
