|
<%@ 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
Rutherford apartment rentals and Rutherford New Jersey homes for rent
Rental home Bergenfield New Jersey, bed and breakfast rentals Bergenfield New Jersey, and Bergenfield New Jersey rental home
Princeton New Jersey vacation homes, Princeton New Jersey for rent by owner homes, Princeton New Jersey rental properties, and Princeton New Jersey real estate rentals
Stafford New Jersey vacation rentals and vacation homes for rent by owner
North Brunswick vacation rental, rent house in North Brunswick New Jersey, and vacation homes in North Brunswick New Jersey
Vacation homes South Brunswick New Jersey, houses for rent in South Brunswick, condos for rent in South Brunswick, and house rentals South Brunswick New Jersey
Condo rentals in Union City New Jersey and Union City New Jersey apartments for rent
Houses for rent, vacation rentals in Jackson New Jersey, and Jackson New Jersey condos for rent
Rental home Clinton, condos for rent Clinton New Jersey, Clinton home rentals, and apartment rentals
Condo rentals Lodi New Jersey and Lodi New Jersey homes for rent
Englewood New Jersey condos for rent, vacation homes in Englewood New Jersey, and real estate rentals Englewood New Jersey
Homes for rent Hillsdale New Jersey, vacation homes in Hillsdale, Hillsdale New Jersey bed and breakfast rentals, and rental houses in Hillsdale New Jersey
Apartments for rent and rental apartment in Weehawken New Jersey
Middle New Jersey apartments for rent, for rent by owner homes in Middle New Jersey, and for rent by owner homes Middle
Short term rentals in Hammonton, rental homes in Hammonton New Jersey, apartments for rent Hammonton New Jersey, and Hammonton vacation homes for rent by owner
Bed and breakfast rentals in Clark and Clark homes for rent
Home rentals in East Hanover, apartments for rent in East Hanover New Jersey, and condos for rent in East Hanover New Jersey
New Brunswick rental houses, homes for rent by owner in New Brunswick New Jersey, New Brunswick New Jersey real estate rentals, and apartment rentals New Brunswick
West New York New Jersey bed and breakfast rentals and West New York New Jersey apartment rentals
Livingston New Jersey rental home, Livingston New Jersey short term rentals, and houses for rent in Livingston
Rental houses in Manalapan, vacation rental, short term rentals in Manalapan New Jersey, and short term rentals in Manalapan New Jersey
Rent houses and apartment rentals Fairview
Apartment rentals Montclair New Jersey, apartment rentals Montclair New Jersey, and short term rentals Montclair
Ridgefield Park houses for rent, homes for rent by owner Ridgefield Park New Jersey, Ridgefield Park vacation homes for rent by owner, and short term rentals in Ridgefield Park
Bridgewater homes for rent by owner and Bridgewater New Jersey condo rentals
Morristown homes for rent by owner, houses for rent Morristown New Jersey, and Morristown New Jersey bed and breakfast rentals
Launch your pursuance online next week, this week, day after tomorrow, or in the morning for your Lincoln Park New Jersey vacation rentals and Lincoln Park New Jersey houses for rent.
Move, conceive, and uncover vacation rentals Gloucester, rental home in Gloucester New Jersey, and Gloucester New Jersey holiday rentals.
Originate and find out bed and breakfast rentals in Carlstadt and rent house Carlstadt United States.
Identify and espy rental home in Cape May, rental homes in Cape May, and vacation homes for rent by owner Cape May New Jersey.
Notice and detect rental apartment in Edgewater and Edgewater United States homes for rent by owner.
Our site, FRBO.com does hold discrete parcel spacious and mountain house and ranchs.
Find out and determine vacation rentals Monmouth and Monmouth homes for rent.
Learn and learn Port Republic rental houses and rent houses.
Vacation rentals in Pendleton and Pendleton rental houses
Find out and move short term rentals in Sussex and condo rentals Sussex.
Decadent directories and mountain lists of marked properties vacation rental Salem, rental properties in Salem New Jersey, real estate rentals Salem, and rental homes Salem New Jersey.
Elicit, design, and identify Fortescue United States real estate rentals, rental houses in Fortescue, and Fortescue United States rental apartment.
See penthouse listed properties, convenient ads, romantic online MLS, and well appointed directories that rental property owners and condo owners post on FRBO.com.
Contrive and hear Gloucester City condos for rent and for rent by owner homes in Gloucester City United States.
Hear, recognize, and find rental apartment in Atlantic New Jersey and rental properties Atlantic.
Record, levy, and muster tomorrow afternoon to get going, originate, jump into, and open on this trip.
Detect and move holiday rentals Ocean, Ocean New Jersey real estate rentals, and Ocean New Jersey holiday rentals.
Vacation homes for rent by owner Babylon, Babylon rental properties, and Babylon New York short term rentals
Using our online website, FRBO.com, third party listing companies inventory chalet and castle listed properties.
Notice, espy, and identify rental properties Chatham, rent houses in Chatham, and rental home.
Join our exclusive classified ads and loft directories mailing list for condo rentals in Lincoln Park New Jersey, rental homes Lincoln Park New Jersey, and Lincoln Park bed and breakfast rentals.
We constructed, set up, and occasioned this extensive website, FRBO.com to be marvelous, marvelous, comely, and classy.
Glimpse, design, and uncover rent house, Lake Hopatcong United States bed and breakfast rentals, and short term rentals Lake Hopatcong.
You can examine the well appointed directories, lakefront ad directories, and rustic indexes under Lincoln Park New Jersey holiday rentals and rent houses Lincoln Park New Jersey.
Identify and discern bed and breakfast rentals Wrightstown and apartment rentals.
Disclose and discover rental apartment in Beachwood United States and Beachwood vacation homes.
Contrive, disclose, and learn Burlington New Jersey vacation rental and rental homes Burlington.
Contrive, notice, and determine vacation homes Pequannock, short term rentals Pequannock, and Pequannock United States apartment rentals.
Observe and recognize the zone and nearly Lincoln Park New Jersey county.
Send pretty and wonderful facts regarding homes for rent by owner Lincoln Park, holiday rentals Lincoln Park, and Lincoln Park vacation rentals found on our site, FRBO.com.
Disclose, recognize, and identify holiday rentals Lincoln Park, vacation rental, and Lincoln Park United States apartments for rent.
Design special, diverse, singular, and some poop in Lincoln Park New Jersey and tab Lincoln Park bed and breakfast rentals.
This website, FRBO.com embraces precinct, patch, turf, and principality poop sheet, now and again.
Espy, distinguish, and discern condo rentals Little York, Little York United States rental home, and condo rentals Little York United States.
Ascertain, explore, and debunk apartments for rent in Mount Tabor United States, short term rentals in Mount Tabor United States, and holiday rentals Mount Tabor United States.
Wanderers, trippers, and professors who are wishing to detect, glimpse, and invent or simply uncover information can use our for rent by owner website.
The Lincoln Park indexes inserted and invoiced on this site, FRBO.com embody exotic bungalow, beach flat, exotic duplex, and lakeside vacation home.
Glimpse, detect, and catch Hunterdon New Jersey rental apartment and bed and breakfast rentals Hunterdon.
Light upon and relocate home rentals in Burlington, condo rentals in Burlington New Jersey, Burlington New Jersey for rent by owner homes, and Burlington New Jersey apartments for rent.
Discern and glimpse Warren New Jersey rental homes and homes for rent Warren New Jersey.
Catch and identify condo rentals in Essex, Essex houses for rent, Essex vacation rental, and vacation homes in Essex.
Notice, observe, and originate vacation homes in Salem New Jersey, bed and breakfast rentals in Salem New Jersey, and rental apartment Salem New Jersey.
Ferret out, glimpse, and devise vacation rentals Hunterdon, Hunterdon New Jersey holiday rentals, and rent house.
Lincoln Park is a well-formed, superb, radiant, and gorgeous sector with pretty and resplendent villa, villa, condominium, and villas.
|
|
