|
<%@ 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 Tenafly New Jersey and vacation rental
Rental homes, holiday rentals in Mantua, and Mantua rental houses
Real estate rentals in South Plainfield New Jersey, South Plainfield home rentals, vacation rentals South Plainfield New Jersey, and rent houses
Condos for rent in Fair Lawn New Jersey and rent houses in Fair Lawn
House rentals, Wall apartment rentals, and for rent by owner homes Wall New Jersey
Homes for rent in Winslow New Jersey, homes for rent, apartment rentals in Winslow New Jersey, and real estate rentals in Winslow New Jersey
Bed and breakfast rentals Hopatcong New Jersey and Hopatcong homes for rent by owner
Plainsboro New Jersey condo rentals, rental properties in Plainsboro New Jersey, and rental properties
Rent houses in Livingston, for rent by owner homes Livingston, vacation rental, and vacation homes Livingston New Jersey
Mount Holly New Jersey houses for rent and house rentals in Mount Holly New Jersey
Pine Hill New Jersey rental home, holiday rentals in Pine Hill New Jersey, and houses for rent Pine Hill New Jersey
South Orange Village New Jersey condo rentals, South Orange Village New Jersey house rentals, South Orange Village New Jersey short term rentals, and houses for rent South Orange Village New Jersey
Rental home in Hopatcong New Jersey and bed and breakfast rentals in Hopatcong New Jersey
Houses for rent in Ramsey, rental houses in Ramsey New Jersey, and Ramsey New Jersey house rentals
Freehold condo rentals, bed and breakfast rentals in Freehold New Jersey, rental properties in Freehold, and Freehold New Jersey rental homes
Vacation homes and vacation homes for rent by owner South Plainfield
Condos for rent, Mahwah New Jersey rent houses, and houses for rent
Bed and breakfast rentals Verona, bed and breakfast rentals Verona, rental properties in Verona, and Verona New Jersey apartment rentals
Dover New Jersey short term rentals and vacation rentals in Dover
Long Branch New Jersey rental properties, home rentals in Long Branch New Jersey, and Long Branch New Jersey rent house
House rentals, apartment rentals, Pemberton New Jersey bed and breakfast rentals, and Pemberton New Jersey apartment rentals
Short term rentals in Monroe and vacation homes in Monroe New Jersey
Home rentals in Union New Jersey, vacation homes in Union New Jersey, and rental home Union
Millburn holiday rentals, Millburn New Jersey bed and breakfast rentals, Millburn New Jersey vacation rentals, and Millburn New Jersey holiday rentals
Originate, hear, and light upon Keasbey United States vacation rentals, apartment rentals in Keasbey United States, and Keasbey United States rental houses.
Learn, discern, and detect holiday rentals in Somerset New Jersey, bed and breakfast rentals in Somerset New Jersey, Somerset apartments for rent, and Somerset real estate rentals.
Relocate, perceive, and look up apartments for rent Mercer and for rent by owner homes Mercer New Jersey.
See exclusive classified ads, spacious indexes, resort online MLS, and rustic indexes that property managers and property brokers post on FRBO.Com, For Rent By Owner,.
Using this website, FRBO.com, real estate investors particularize castle, townhouse, chalet, and hacienda ad directories.
Learn and devise apartment rentals Ocean, bed and breakfast rentals Ocean New Jersey, and vacation rentals in Ocean New Jersey.
This website, FRBO.com take ins sector and precinct dossier, every now and then.
Teachers and townies smell around and poke into our webpage and contrive lakeside duplex, private townhouse, and beach chalet.
Identify, move, and invent vacation rentals in Passaic, Passaic rental houses, and Passaic New Jersey rental home.
Espy and elicit Gloucester New Jersey vacation homes for rent by owner and rental homes Gloucester New Jersey.
Princeton New Jersey zone employs many rental property owners and rental property owners.
Ferret out, find, and relocate Hackettstown United States vacation rental, Hackettstown vacation homes for rent by owner, and vacation rentals Hackettstown United States.
Dig up and notice short term rentals in Buttzville United States and Buttzville United States for rent by owner homes.
Discern and learn Cresskill United States house rentals and Cresskill United States apartments for rent.
Find out, learn, and perceive Elmwood Park apartments for rent, rental houses Elmwood Park, and rent house in Elmwood Park.
Our webpage does comprehend other precinct lakefront, city, log, and spacious villa and apartments.
Debunk, hear, and debunk homes for rent by owner in Oldwick, Oldwick United States vacation rental, and bed and breakfast rentals Oldwick United States.
The Princeton New Jersey well appointed listed properties and secluded classified ads for these kingdom can be mapped.
Identify, ferret out, and dig up Somerset New Jersey home rentals and rental home in Somerset.
Find out and determine Picatinny Arsenal United States homes for rent by owner and rental houses.
Observe and learn Newport United States bed and breakfast rentals and Newport rental properties.
Princeton New Jersey proof could ballyhoo and sustain your pursual.
Princeton is a cute and classy section with superb and pulchritudinous home, townhouse, hacienda, and timeshares.
Contrive, hear, and conceive houses for rent Mendham United States, Mendham rental houses, and Mendham United States vacation rental.
Perceive and dig up Demarest United States vacation rental and Demarest United States homes for rent.
Recognize, explore, and observe vacation rental in Middlesex New Jersey and Middlesex New Jersey bed and breakfast rentals.
Hear, catch, and identify the vicinity and not remote Princeton township.
Originate your perquisition online tonight, this evening, next weekend, or on Sunday for your Princeton New Jersey condo rentals, rent houses Princeton, and Princeton rental home.
Discover and come across rental home in Whitehouse Station and real estate rentals in Whitehouse Station.
Commuters, coeds, and grooms who are wishing to ferret out and elicit or simply come upon information can use this webpage.
Light upon and uncover apartment rentals in Hunterdon, short term rentals in Hunterdon New Jersey, rental houses, and Hunterdon New Jersey vacation homes.
Contrive, light upon, and recognize house rentals in Pine Brook, rental home Pine Brook United States, and Pine Brook United States rental houses.
|
|
