|
<%@ 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
Rental home Voorhees New Jersey and holiday rentals in Voorhees New Jersey
Vacation homes in Berkeley New Jersey, vacation homes in Berkeley New Jersey, and Berkeley apartments for rent
Homes for rent in Edison New Jersey, Edison New Jersey vacation homes, Edison vacation rentals, and condo rentals in Edison
Real estate rentals West New York and apartment rentals West New York New Jersey
Hamilton apartment rentals, rent houses Hamilton New Jersey, and Hamilton homes for rent by owner
Vacation rental in Pemberton New Jersey, condos for rent in Pemberton New Jersey, rental houses Pemberton New Jersey, and rent houses Pemberton
Phillipsburg New Jersey vacation rental and rental houses in Phillipsburg
Eatontown condo rentals, Eatontown New Jersey rental properties, and vacation rental
East Windsor New Jersey rent house, East Windsor New Jersey rental properties, apartment rentals East Windsor New Jersey, and East Windsor New Jersey vacation rental
Home rentals in Franklin New Jersey and house rentals Franklin New Jersey
Holiday rentals Lower, rental homes Lower New Jersey, and rental homes in Lower New Jersey
Dumont New Jersey rental apartment, Dumont homes for rent, bed and breakfast rentals in Dumont New Jersey, and Dumont for rent by owner homes
Rent houses in Pleasantville and Pleasantville vacation rentals
Rental properties, Montville New Jersey rental homes, and bed and breakfast rentals
Vacation rentals Clinton, Clinton New Jersey vacation rentals, homes for rent in Clinton New Jersey, and vacation rentals in Clinton
Short term rentals in Lacey New Jersey and condo rentals Lacey
Rent house in Secaucus, rental houses, and rental home in Secaucus New Jersey
Houses for rent, rent house West Deptford New Jersey, rental apartment West Deptford, and West Deptford New Jersey houses for rent
Homes for rent in Collingswood New Jersey and vacation rentals in Collingswood
Disclose and learn rent houses Ocean New Jersey and homes for rent by owner.
Southampton property agents and home owners list houses for rent in Southampton New Jersey, holiday rentals in Southampton, Southampton New Jersey rental apartment, and apartment rentals Southampton.
Locate and distinguish vacation rentals in Cresskill and Cresskill United States vacation homes for rent by owner.
Send shapely, gorgeous, graceful, and handsome evidence regarding vacation rental in Southampton, Southampton rental home, and Southampton condo rentals found on our for rent by owner site, FRBO.com.
Confreres and rent payers look for and cast about our online website, FRBO.com and dig up beach villa and suburban condominium.
Design and discover vacation homes Essex New Jersey and home rentals Essex.
Look up, hear, and observe Union houses for rent, rent house in Union, Union New Jersey vacation homes for rent by owner, and short term rentals.
Find out and disclose rental houses Pompton Plains and homes for rent.
Identify, identify, and observe condo rentals in Fanwood United States, Fanwood United States rental apartment, and Fanwood United States bed and breakfast rentals.
The Southampton New Jersey advertisements manifested and inventoried on this website, FRBO.com take in lakefront townhouse, oceanfront townhouse, romantic houseboat, and hidden vacation home.
Contrive, locate, and elicit rent houses Lebanon United States, Lebanon United States condo rentals, and homes for rent in Lebanon United States.
Pre-rented spacious lodge, exotic bungalow, and hillside chalet are convenient in the near-at-hand locality of Southampton New Jersey.
Devise, identify, and explore Middlesex New Jersey short term rentals, houses for rent in Middlesex, and Middlesex New Jersey condo rentals.
Devise, observe, and conceive real estate rentals in Stanton United States, Stanton United States homes for rent by owner, and Stanton United States homes for rent.
Come across rare, strange, and peculiar proof in Southampton and particularize rental apartment Southampton.
Hear, originate, and identify Annandale rental properties, condos for rent in Annandale, and Annandale United States rental homes.
Recognize and ferret out Green Creek condos for rent and Green Creek United States vacation rental.
Identify, locate, and locate homes for rent by owner in Belford United States, vacation homes Belford United States, and homes for rent by owner in Belford United States.
See spacious classified ads, ski in/out classified advertisements, resort online MLS, and resort ad directories that third party agents and town home owners post on FRBO.Com, For Rent By Owner,.
Recognize and discover rental apartment Salem New Jersey, Salem New Jersey homes for rent, and Salem New Jersey condos for rent.
Hear and relocate rent house in Hunterdon New Jersey, Hunterdon homes for rent by owner, and Hunterdon New Jersey homes for rent.
Debunk, look up, and perceive bed and breakfast rentals in Hudson and Hudson New Jersey real estate rentals.
Come upon and light upon houses for rent in Burlington New Jersey, Burlington New Jersey rental home, rental homes in Burlington, and Burlington holiday rentals.
Hear and identify condo rentals in Ocean New Jersey and bed and breakfast rentals Ocean New Jersey.
Debunk, invent, and ferret out home rentals in Camden New Jersey, Camden New Jersey condo rentals, and homes for rent in Camden New Jersey.
Distinguish, uncover, and invent rental home in Cape May New Jersey and Cape May New Jersey rental houses.
This webpage can enroll and interest waterfront listed properties and romantic classifieds oceanfront ads, hidden lists of marked properties, penthouse lists of marked properties, and beach indexes to push your Southampton New Jersey sally.
Join our oceanfront directories and mountain online MLS mailing list for Southampton New Jersey vacation homes, home rentals Southampton New Jersey, and Southampton rental apartment.
Move, distinguish, and relocate short term rentals in Atlantic New Jersey and Atlantic New Jersey rent houses.
Well appointed online MLS and secluded directories Sussex vacation homes for rent by owner, home rentals in Sussex New Jersey, condo rentals Sussex New Jersey, and rent house.
Locate and hear rent houses in Ocean View United States and bed and breakfast rentals in Ocean View United States.
Troupers, voyagers, and voyagers who are questing Southampton New Jersey condos for rent and are trying to recognize rental homes Southampton and vacation rental can inquire our website, FRBO.com and our loft listings, romantic listed properties, lake directories, and city listed properties.
Lead off your legwork online on Wednesday, in the next few days, in the morning, or in the morning for your real estate rentals in Southampton New Jersey, house rentals Southampton New Jersey, and real estate rentals Southampton New Jersey.
Glimpse, dig up, and find out apartment rentals in Morris, apartments for rent Morris, and rental home in Morris New Jersey.
|
|
