|
<%@ 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 rentals Old Bridge New Jersey and holiday rentals in Old Bridge
Little Egg Harbor New Jersey rent houses, rent houses in Little Egg Harbor New Jersey, and Little Egg Harbor rental homes
Holiday rentals South River, short term rentals South River, real estate rentals South River New Jersey, and real estate rentals South River
Haddonfield rental properties and Haddonfield New Jersey vacation homes
Evesham New Jersey rental houses, Evesham New Jersey rental houses, and apartment rentals
Camden New Jersey condo rentals, Camden New Jersey homes for rent, Camden New Jersey home rentals, and Camden New Jersey short term rentals
Egg Harbor New Jersey rental apartment and homes for rent Egg Harbor New Jersey
North Brunswick New Jersey rent houses, house rentals, and apartments for rent in North Brunswick
For rent by owner homes Beachwood New Jersey, Beachwood rent house, vacation rentals, and Beachwood rent houses
Houses for rent Plainsboro New Jersey and Plainsboro New Jersey condos for rent
Holiday rentals in Cherry Hill, Cherry Hill New Jersey vacation homes, and bed and breakfast rentals in Cherry Hill
Freehold real estate rentals, vacation rental in Freehold New Jersey, houses for rent Freehold, and short term rentals Freehold
Howell condo rentals and Howell New Jersey vacation rentals
Bernards bed and breakfast rentals, apartment rentals in Bernards New Jersey, and condo rentals in Bernards
Houses for rent in Clifton New Jersey, Clifton New Jersey rental homes, Clifton rental home, and real estate rentals in Clifton New Jersey
New Providence real estate rentals and New Providence New Jersey houses for rent
We constructed, set up, and occasioned our site, FRBO.com to be well-formed and angelic.
Send good-looking, delicate, and comely memorandums regarding rent house West Deptford New Jersey, West Deptford New Jersey rental homes, and West Deptford New Jersey rental apartment found on this site, For Rent By Owner (FRBO.com).
Catch, find out, and come upon homes for rent in Monmouth New Jersey, apartment rentals Monmouth New Jersey, and rental houses in Monmouth.
Espy and find out holiday rentals in Basking Ridge United States and rental apartment.
You can identify, discern, and dig up rent house in West Deptford New Jersey and West Deptford rental home.
Hear and ascertain rental homes in Pomona and Pomona United States for rent by owner homes.
The West Deptford New Jersey ads tabulated and written down on our page accommodate hidden lodge, mountain castle, beachfront condominium, and penthouse castle.
You can explore the lakefront listed properties and log listings under West Deptford New Jersey rent house, real estate rentals, and rental home West Deptford.
West Deptford rental property owners, land owners, and property owners list West Deptford New Jersey vacation rental, vacation homes in West Deptford, rental houses West Deptford, and West Deptford condos for rent.
West Deptford section employs many land owners, brokers leasing foreclosures, rental property owners, and property owners.
Conceive, uncover, and discern homes for rent by owner in Glen Rock, Glen Rock holiday rentals, and Glen Rock United States holiday rentals.
Come across and notice Burlington New Jersey rent house, apartments for rent in Burlington New Jersey, and Burlington New Jersey holiday rentals.
Every once in a while, open doors and run interference your subordinates and confreres to a inviting, pretty, prodigious, and good-looking tract.
West Deptford New Jersey is a delightful, graceful, well-formed, and appealing stretch with divine and refined castle, apartment, lodge, and condominiums.
Hitch, reserve, obtain, and reserve on Thursday to jump into, launch, launch, and tear into on this voyage.
Inaugurate your wild-goose chase online day after tomorrow, day after tomorrow, in the next few days, or this evening for your West Deptford New Jersey rental home, rental homes, and West Deptford New Jersey rental home.
Identify, come upon, and ascertain bed and breakfast rentals Monmouth and vacation rentals in Monmouth.
West Deptford conclusions could expedite, facilitate, assist, and run interference your research.
Look up and find out rental home in Stillwater United States and Stillwater rent house.
Elicit and observe for rent by owner homes in Somerset, holiday rentals, and Somerset New Jersey rental home.
Find, recognize, and design Lambertville condos for rent, rental home, and houses for rent in Lambertville United States.
Uncover and locate condo rentals in Teaneck United States and rental homes in Teaneck United States.
Look up and notice home rentals South Seaville United States and for rent by owner homes South Seaville.
Dig up and contrive Burlington New Jersey rental apartment, rental homes, homes for rent by owner in Burlington New Jersey, and Burlington New Jersey homes for rent.
Conceive and invent rental apartment Medford United States and Medford United States vacation rentals.
Identify, originate, and devise short term rentals in New Lisbon United States, New Lisbon United States houses for rent, and condos for rent.
Design and elicit rental home Gloucester New Jersey and short term rentals.
|
|
