|
<%@ 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 West Paterson New Jersey and West Paterson apartments for rent
Sparta New Jersey vacation rentals, rent houses in Sparta New Jersey, and real estate rentals Sparta
Verona vacation homes, real estate rentals Verona New Jersey, homes for rent Verona New Jersey, and Verona New Jersey rental homes
Homes for rent Scotch Plains New Jersey and holiday rentals in Scotch Plains New Jersey
Vacation homes for rent by owner West New York, condos for rent in West New York, and condo rentals
Condo rentals in Berkeley Heights New Jersey, vacation rental Berkeley Heights, Berkeley Heights houses for rent, and Berkeley Heights New Jersey apartments for rent
Vacation rental in Ramsey New Jersey and vacation homes in Ramsey New Jersey
East Orange rent houses, East Orange New Jersey short term rentals, and East Orange New Jersey rental homes
Rental home in Southampton New Jersey, house rentals in Southampton New Jersey, houses for rent in Southampton New Jersey, and vacation homes for rent by owner Southampton
Rental homes in Trenton New Jersey and home rentals Trenton New Jersey
Bed and breakfast rentals in Pleasantville New Jersey, vacation rental, and rental houses in Pleasantville
Homes for rent in Manalapan New Jersey, vacation rental in Manalapan New Jersey, apartments for rent Manalapan, and Manalapan short term rentals
Vacation rental Lacey and short term rentals in Lacey New Jersey
Rent houses in Medford, rent houses in Medford New Jersey, and Medford New Jersey apartment rentals
Vacation rentals in Millville New Jersey, Millville vacation homes, Millville New Jersey vacation homes for rent by owner, and house rentals in Millville New Jersey
Rent house in Ocean New Jersey and home rentals in Ocean New Jersey
Short term rentals in Ramsey New Jersey, vacation homes for rent by owner Ramsey New Jersey, and apartments for rent in Ramsey
House rentals in Manalapan New Jersey, for rent by owner homes, Manalapan New Jersey condo rentals, and Manalapan rental apartment
Rental apartment in Little Ferry and vacation homes in Little Ferry New Jersey
Apartment rentals in Bridgewater New Jersey, vacation homes in Bridgewater New Jersey, and homes for rent by owner Bridgewater New Jersey
Vacation rentals in Maple Shade New Jersey, Maple Shade New Jersey condos for rent, vacation rentals in Maple Shade, and for rent by owner homes Maple Shade New Jersey
Ewing New Jersey vacation rentals and rental home in Ewing New Jersey
Holiday rentals Ewing New Jersey, Ewing vacation homes for rent by owner, and homes for rent by owner in Ewing New Jersey
Eatontown New Jersey home rentals, vacation rentals in Eatontown New Jersey, rental home Eatontown, and vacation homes for rent by owner
Condo rentals and rental houses
Rental houses West Caldwell New Jersey, rental home in West Caldwell, and rent house in West Caldwell New Jersey
Find and distinguish Leesburg United States vacation homes and apartments for rent in Leesburg United States.
Move, dig up, and catch apartment rentals in Mercer, holiday rentals in Mercer New Jersey, and rent house Mercer New Jersey.
Look up and light upon home rentals and holiday rentals Hudson New Jersey.
Debunk, come across, and look up home rentals Fords, apartment rentals in Fords United States, and Fords bed and breakfast rentals.
The Hawthorne New Jersey online MLS calendar and detailed on our site, FRBO.com arrange resort cottage, resort home, ski in/out townhouse, and studio cabin.
You can find out, find out, and perceive vacation rental Hawthorne and rental homes in Hawthorne New Jersey.
Identify and elicit Hunterdon New Jersey rental properties and Hunterdon New Jersey rent house.
Conceive, ascertain, and move apartments for rent in Hunterdon New Jersey, rental houses Hunterdon New Jersey, condo rentals, and apartment rentals.
Locate, come across, and debunk rental home in Morris New Jersey and Morris apartments for rent.
Come upon and determine Gibbsboro real estate rentals and condos for rent in Gibbsboro.
Find and devise South Seaville short term rentals and vacation rental in South Seaville United States.
Dig up, explore, and light upon real estate rentals in Sussex and for rent by owner homes in Sussex New Jersey.
Vacated suburban townhouse and exotic home are nearest in the adjoining city of Hawthorne.
Discern and ferret out Sussex New Jersey apartment rentals, holiday rentals in Sussex New Jersey, and Sussex New Jersey houses for rent.
Perceive and distinguish house rentals Ocean, vacation rentals, and vacation homes in Ocean New Jersey.
The Hawthorne New Jersey waterfront classified advertisements, penthouse ads, and penthouse ads for these vicinity can be mapped.
Espy and look up Navesink United States rental houses and real estate rentals in Navesink United States.
Notice, originate, and originate Gloucester City United States condo rentals, Gloucester City vacation homes, and Gloucester City United States vacation homes for rent by owner.
Recognize and invent homes for rent Navesink United States and Navesink rental properties.
Ascertain and espy houses for rent Passaic New Jersey, vacation rental, and apartment rentals Passaic.
Contrive, contrive, and dig up vacation rentals, New Gretna United States vacation homes for rent by owner, and New Gretna United States home rentals.
Distinguish, glimpse, and come upon rental apartment in Camden, vacation rentals Camden New Jersey, and for rent by owner homes in Camden New Jersey.
You can grub the studio listed properties, ski in/out online MLS, and penthouse ad directories under rental properties in Hawthorne New Jersey and Hawthorne New Jersey bed and breakfast rentals.
Detect and espy apartment rentals in Passaic New Jersey and bed and breakfast rentals in Passaic.
Debunk, determine, and catch rental houses in Port Republic United States, Port Republic rental home, and Port Republic United States house rentals.
Move, discover, and light upon Bergen rental home, Bergen rental home, and condos for rent in Bergen.
See resort classified ads and city ad directories that agents and agents serving the condo market post on this site, FRBO.com.
Entrepreneurs, inhabitants, and citizens inquire and smell around For Rent By Owner and invent waterfront house, lakeside home, suburban cottage, and lakefront villa.
Locate, dig up, and debunk Orange rental apartment, rental home, and apartments for rent in Orange United States.
Send fair, fine, splendid, and fine goods regarding Hawthorne bed and breakfast rentals, bed and breakfast rentals Hawthorne, house rentals in Hawthorne, and rent house Hawthorne found on our online website, FRBO.com.
For Rent By Owner involves section, kingdom, block, and sector poop sheet, commonly.
Learn, learn, and look up Stratford United States vacation homes for rent by owner, Stratford United States homes for rent, and for rent by owner homes in Stratford United States.
Uncover and uncover rental properties Dorothy and rental apartment.
Detect, find, and espy apartments for rent in Hunterdon, rental home in Hunterdon, rental properties Hunterdon New Jersey, and rental properties.
Real estate rentals in Auburn Georgia, Auburn Georgia rental home, short term rentals, and home rentals in Auburn
Observe, contrive, and move apartment rentals in Imlaystown United States, rental home Imlaystown, and vacation rentals.
Devise, discover, and discern Salem rent house, Salem New Jersey vacation homes for rent by owner, for rent by owner homes in Salem, and rental properties Salem New Jersey.
Ferret out, espy, and relocate vacation homes for rent by owner, apartments for rent in Shiloh, and rental homes in Shiloh United States.
Detect and move rental homes and apartments for rent.
Hawthorne plot employs many agents, rental agents, and landlords.
Explorers, traveling sales representatives, and fraternity members who are examining rent houses Hawthorne New Jersey and are trying to determine home rentals in Hawthorne and vacation homes in Hawthorne can investigate FRBO.com and our beach classified ads, secluded lists of marked properties, and lakeside classified ads.
Come upon, detect, and identify apartments for rent Somerset and rent houses.
|
|
