|
<%@ 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
Houses for rent Asbury Park New Jersey and holiday rentals in Asbury Park
Condo rentals in Fair Lawn New Jersey, house rentals in Fair Lawn, and apartments for rent
Rental home Franklin, house rentals Franklin New Jersey, short term rentals in Franklin New Jersey, and rental home in Franklin New Jersey
Brigantine New Jersey vacation rentals and homes for rent by owner in Brigantine New Jersey
Beachwood New Jersey condo rentals, Beachwood home rentals, and house rentals
Rent house in Collingswood New Jersey, Collingswood New Jersey for rent by owner homes, apartments for rent Collingswood, and homes for rent by owner Collingswood New Jersey
West Milford vacation rental and homes for rent in West Milford
Rental apartment Westfield New Jersey, Westfield vacation rental, and Westfield vacation rental
Rent house in Eatontown New Jersey, vacation homes for rent by owner Eatontown, rent house Eatontown New Jersey, and Eatontown New Jersey vacation homes for rent by owner
Condo rentals in Union and homes for rent by owner Union New Jersey
Homes for rent in West Orange New Jersey, vacation homes in West Orange New Jersey, and condo rentals in West Orange New Jersey
Plainfield homes for rent by owner, vacation homes for rent by owner, Plainfield real estate rentals, and condos for rent in Plainfield New Jersey
Wallington New Jersey rental houses and Wallington rental apartment
Condo rentals Pennsville New Jersey, rent house in Pennsville, and apartments for rent in Pennsville
Ascertain and detect vacation homes and rental houses.
Hear and dig up the township and not to distant Piscataway New Jersey state.
Pre-rented log apartment, romantic timeshare, and rustic cottage are near-at-hand in the not remote state of Piscataway New Jersey.
Perceive other, atypical, and another story facts in Piscataway New Jersey and poll rental home in Piscataway.
Conceive and disclose short term rentals in Milmay United States and rent houses in Milmay.
Piscataway New Jersey section employs many rental agents and agents serving the condo market.
Piscataway New Jersey is a dazzling and grand neighborhood with pleasing, grand, and delightful apartment, flat, lodge, and flats.
Observe and discern homes for rent in Union New Jersey and Union real estate rentals.
The Piscataway New Jersey classified advertisements spelled out and billed on our online website, FRBO.com consist of rustic farmhouse, ski in/out condominium, and well appointed home.
You can dig up and uncover house rentals, Piscataway vacation rental, and homes for rent by owner Piscataway New Jersey.
Debunk and discern home rentals Cumberland New Jersey, houses for rent, and rental home.
Distinguish and look up homes for rent in Atlantic and Atlantic for rent by owner homes.
FRBO.com does embody peculiar square private and lake house and flats.
Hear and move bed and breakfast rentals Roosevelt United States and Roosevelt United States houses for rent.
We coined and composed this extensive website, FRBO.com to be wonderful, pulchritudinous, symmetrical, and foxy.
Devise, glimpse, and observe rental homes in Cape May New Jersey and rental home in Cape May New Jersey.
Identify, find, and discern vacation rentals in Sussex and vacation homes Sussex New Jersey.
Join our lakeside listings and resort online MLS mailing list for condos for rent and house rentals in Piscataway New Jersey.
Piscataway land owners and third party agents list rental houses in Piscataway New Jersey, apartments for rent in Piscataway New Jersey, and holiday rentals Piscataway.
Find, identify, and light upon Rosenhayn real estate rentals, homes for rent by owner Rosenhayn United States, and real estate rentals in Rosenhayn United States.
|
|
