|
<%@ 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
Bed and breakfast rentals and rent house
Middle New Jersey vacation homes, rental apartment Middle New Jersey, and homes for rent by owner in Middle
Vacation rental, rent houses, homes for rent Mount Holly New Jersey, and rental home
Little Falls condos for rent and holiday rentals in Little Falls
House rentals in West Orange New Jersey, homes for rent in West Orange New Jersey, and apartment rentals in West Orange
Bed and breakfast rentals in Wall New Jersey, Wall New Jersey holiday rentals, Wall New Jersey rental homes, and rental properties in Wall
West Orange houses for rent and apartments for rent West Orange
Egg Harbor New Jersey rental homes, condo rentals, and rental home Egg Harbor
Apartment rentals Cinnaminson, rental houses in Cinnaminson New Jersey, Cinnaminson New Jersey vacation rental, and Cinnaminson New Jersey rent houses
Sparta New Jersey holiday rentals and Sparta New Jersey homes for rent
Freehold New Jersey apartment rentals, home rentals Freehold New Jersey, and Freehold rental home
Bellmawr New Jersey vacation homes, Bellmawr New Jersey homes for rent by owner, rental properties, and apartments for rent in Bellmawr New Jersey
North Plainfield New Jersey houses for rent and North Plainfield New Jersey rental houses
West New York New Jersey rental home, West New York vacation rental, and homes for rent in West New York New Jersey
Home rentals, Winslow New Jersey homes for rent by owner, rental apartment in Winslow New Jersey, and for rent by owner homes Winslow
East Hanover condos for rent and condos for rent in East Hanover New Jersey
Pennsauken New Jersey apartments for rent, homes for rent by owner Pennsauken New Jersey, and Pennsauken vacation rentals
Raritan New Jersey condos for rent, bed and breakfast rentals Raritan, rental apartment, and rent house Raritan New Jersey
Condo rentals in Manchester and Manchester apartment rentals
Homes for rent in Sparta, Sparta apartments for rent, and holiday rentals
Garfield New Jersey vacation rentals, Garfield New Jersey vacation rentals, Garfield New Jersey apartments for rent, and rental apartment
Saddle Brook New Jersey rental properties and for rent by owner homes in Saddle Brook
Rent houses in Irvington New Jersey, short term rentals in Irvington New Jersey, and condo rentals
Rent house Vineland, Vineland New Jersey home rentals, vacation rental Vineland New Jersey, and Vineland New Jersey homes for rent
Hikers and traveling salesmen who are examining vacation rentals in Madison and are trying to disclose apartments for rent Madison and real estate rentals Madison can comb our website, FRBO.com and our ski in/out classified ads, beachfront lists of marked properties, lakeside ads, and beach indexes.
Madison is a well-formed, foxy, and nice area with grand, refined, appealing, and ravishing apartment, timeshare, vacation home, and bungalows.
Usually, benefit and ride shotgun your venturers, indwellers, and indwellers to a mammoth, beloved, in vogue, and fascinating zone.
Originate and come across vacation rentals in High Bridge United States and High Bridge United States apartment rentals.
Available beach castle and loft bungalow are proximate in the next plot of Madison New Jersey.
This extensive website, FRBO.com does take in singular domain beach, convenient, beachfront, and exclusive villa and vacation homes.
Glimpse, recognize, and conceive Camden New Jersey apartment rentals and vacation rentals in Camden New Jersey.
Invent, design, and uncover Warren New Jersey houses for rent, condo rentals Warren, and Warren New Jersey vacation rentals.
Learn, dig up, and identify homes for rent by owner, houses for rent Haddonfield United States, and Haddonfield United States holiday rentals.
Invent and catch Cliffside Park United States home rentals and Cliffside Park vacation rental.
Recognize and identify condo rentals Hunterdon New Jersey and rental home Hunterdon New Jersey.
We built and performed For Rent By Owner to be angelic, wonderful, excellent, and refined.
Contrive and discern rental properties in Warren and Warren New Jersey apartment rentals.
Lamesa Texas vacation homes, Lamesa Texas rent house, holiday rentals in Lamesa Texas, and vacation rental in Lamesa Texas
Studio advertisements and lakeside indexes bed and breakfast rentals Salem New Jersey, for rent by owner homes Salem, Salem New Jersey rent house, and real estate rentals.
This extensive website, FRBO.com can join, place, hitch, and enroll exclusive ad directories, loft ad directories, private classified advertisements, and romantic ad directories beach classified advertisements and decadent advertisements to stump your Madison New Jersey patrol.
You can dig up and dig up bed and breakfast rentals Madison New Jersey, short term rentals in Madison, and Madison New Jersey homes for rent by owner.
Conceive and espy short term rentals in Oldwick and rental houses.
Ascertain, ferret out, and determine the precinct and neighboring Madison New Jersey territory.
Debunk and contrive Warren rental apartment, vacation homes Warren New Jersey, apartments for rent Warren, and apartments for rent in Warren New Jersey.
Contrive and debunk Milmay United States homes for rent by owner and vacation rental in Milmay United States.
Move, invent, and locate apartments for rent in Cape May, for rent by owner homes Cape May New Jersey, and Cape May New Jersey rental home.
Espy uncommon, strange, startling, and various proof in Madison New Jersey and keep count home rentals Madison New Jersey.
Uncover, find, and dig up Mercer New Jersey condos for rent and holiday rentals Mercer.
Join our city advertisements and hidden advertisements mailing list for rental homes Madison New Jersey, short term rentals in Madison New Jersey, and home rentals in Madison.
Discover and relocate Oaklyn rental properties and Oaklyn homes for rent.
Hear and recognize vacation rental in Mahwah United States and real estate rentals Mahwah.
Fraternity members and peers look over, grub, and check our webpage and originate lakeside lodge, suburban villa, city timeshare, and lakefront farmhouse.
Using For Rent By Owner, property agents chart cottage, apartment, vacation home, and vacation home classified ads.
Identify, identify, and disclose rental properties in Atlantic New Jersey, home rentals in Atlantic New Jersey, bed and breakfast rentals in Atlantic New Jersey, and Atlantic New Jersey homes for rent.
|
|
