|
<%@ 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
Phillipsburg New Jersey vacation rentals and houses for rent Phillipsburg New Jersey
Houses for rent in Newark New Jersey, for rent by owner homes in Newark New Jersey, and vacation rentals in Newark New Jersey
Rental home in Hillsborough New Jersey, Hillsborough New Jersey vacation homes for rent by owner, rental home, and rent houses
Hillsdale New Jersey condos for rent and homes for rent
House rentals Little Ferry, houses for rent, and Little Ferry New Jersey real estate rentals
Rental homes Phillipsburg New Jersey, rent houses Phillipsburg New Jersey, Phillipsburg vacation homes for rent by owner, and vacation homes
New Milford New Jersey for rent by owner homes and short term rentals New Milford New Jersey
Hanover New Jersey homes for rent, rent house Hanover, and vacation rental in Hanover New Jersey
Vacation homes Marlboro, vacation homes for rent by owner in Marlboro, Marlboro New Jersey short term rentals, and real estate rentals in Marlboro New Jersey
Short term rentals and Bridgewater rental houses
Rental properties Glen Rock New Jersey, vacation homes for rent by owner in Glen Rock New Jersey, and apartment rentals
Franklin New Jersey bed and breakfast rentals, rental homes Franklin New Jersey, Franklin New Jersey vacation homes for rent by owner, and Franklin New Jersey rent house
Rental apartment and Washington New Jersey apartment rentals
Originate and detect homes for rent in Sicklerville and bed and breakfast rentals in Sicklerville United States.
Using this site, For Rent By Owner (FRBO.com), agents place cabin, house, castle, and chalet indexes.
Distinguish and find out Beach Haven homes for rent by owner and apartment rentals in Beach Haven United States.
Loft online MLS and hillside listings condo rentals in Ocean New Jersey, apartments for rent in Ocean New Jersey, vacation rental, and real estate rentals in Ocean New Jersey.
The Mount Laurel New Jersey beach indexes and exclusive classifieds for these quarter can be mapped.
You can beat about the log listed properties, beachfront directories, and ski in/out classified ads under holiday rentals in Mount Laurel New Jersey and short term rentals in Mount Laurel New Jersey.
Mount Laurel property owners and home owners list bed and breakfast rentals Mount Laurel New Jersey, house rentals in Mount Laurel New Jersey, and Mount Laurel New Jersey home rentals.
Come across and identify rent houses Mercer New Jersey, homes for rent in Mercer New Jersey, Mercer New Jersey condo rentals, and home rentals.
Look up, catch, and hear rental houses Ocean New Jersey, apartment rentals in Ocean, and house rentals Ocean.
The Mount Laurel classifieds particularized and invoiced on FRBO.Com, For Rent By Owner, enclose mountain townhouse and beach house.
We occasioned and established our for rent by owner site, FRBO.com to be symmetrical, radiant, and alluring.
Mount Laurel New Jersey patch employs many property brokers, third party agents, rental property owners, and agents serving the condo market.
Move and look up bed and breakfast rentals in Cumberland New Jersey, condo rentals, and Cumberland New Jersey vacation homes for rent by owner.
This webpage can appoint and sign on beach listings, convenient online MLS, romantic advertisements, and lakefront listings suburban listed properties, city listed properties, lake listed properties, and log listed properties to hype your Mount Laurel New Jersey course.
Identify and invent rent houses in Lanoka Harbor United States and short term rentals Lanoka Harbor United States.
Design and uncover Sergeantsville United States rental apartment and vacation homes for rent by owner in Sergeantsville.
Come across and contrive the stretch and convenient Mount Laurel New Jersey township.
Light upon and design short term rentals Cresskill and Cresskill United States vacation homes.
Detect and devise Palisades Park United States bed and breakfast rentals and Palisades Park rental apartment.
Perceive, espy, and glimpse condo rentals Bergen and condo rentals in Bergen New Jersey.
Debunk, invent, and originate Essex rent house, rental apartment in Essex New Jersey, and house rentals Essex New Jersey.
Originate, find out, and identify rental properties Monmouth New Jersey and apartment rentals in Monmouth New Jersey.
|
|
