|
<%@ 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 homes for rent by owner Freehold New Jersey and home rentals in Freehold New Jersey
Hammonton New Jersey real estate rentals, Hammonton New Jersey home rentals, and condo rentals in Hammonton
Vacation rentals, home rentals, condos for rent Southampton New Jersey, and Southampton home rentals
Rental properties in Pennsauken and rental properties
Holiday rentals in Paterson New Jersey, house rentals Paterson, and for rent by owner homes in Paterson New Jersey
Holiday rentals in South River, house rentals South River, South River New Jersey rental home, and rental houses
Rental apartment Winslow and Winslow rental properties
Haddonfield New Jersey vacation homes for rent by owner, real estate rentals in Haddonfield New Jersey, and apartment rentals in Haddonfield
Rental home Ocean City New Jersey, short term rentals in Ocean City New Jersey, homes for rent, and houses for rent in Ocean City New Jersey
Rental homes and rent houses in Elizabeth New Jersey
Clinton condo rentals, rental properties Clinton New Jersey, and house rentals in Clinton New Jersey
For rent by owner homes West Windsor New Jersey, vacation homes West Windsor, houses for rent in West Windsor New Jersey, and West Windsor New Jersey short term rentals
Ramsey New Jersey condo rentals and Ramsey New Jersey bed and breakfast rentals
Apartment rentals West Caldwell New Jersey, short term rentals, and rent houses West Caldwell New Jersey
Upper New Jersey houses for rent, vacation rental in Upper, rental homes in Upper New Jersey, and Upper New Jersey homes for rent
House rentals Dover and rental apartment in Dover
Condo rentals in Bernards New Jersey, Bernards New Jersey holiday rentals, and house rentals
Condo rentals, bed and breakfast rentals in Belleville New Jersey, rental properties, and Belleville holiday rentals
Condo rentals in Glen Rock New Jersey and rent houses in Glen Rock New Jersey
Vacation homes for rent by owner in Springfield New Jersey, rental houses in Springfield New Jersey, and Springfield New Jersey vacation homes for rent by owner
Franklin Lakes condo rentals, Franklin Lakes New Jersey rent house, Franklin Lakes rental properties, and Franklin Lakes New Jersey vacation homes for rent by owner
Vacation rental in Mount Olive New Jersey and homes for rent by owner in Mount Olive New Jersey
Rental apartment Lawrence New Jersey, apartments for rent Lawrence New Jersey, and real estate rentals in Lawrence New Jersey
East Hanover New Jersey homes for rent, East Hanover New Jersey rental houses, apartment rentals in East Hanover New Jersey, and short term rentals in East Hanover New Jersey
Rental homes and Pine Hill New Jersey home rentals
Condo rentals Mount Laurel, rent houses Mount Laurel, and rent houses Mount Laurel New Jersey
Vacation homes, Aberdeen rental properties, condo rentals, and short term rentals Aberdeen New Jersey
Vacation rentals Westwood New Jersey and rental home
Condo rentals in Hoboken New Jersey, for rent by owner homes, and vacation homes for rent by owner in Hoboken New Jersey
Vacation homes for rent by owner, Little Ferry rental home, Little Ferry New Jersey rental houses, and rental apartment Little Ferry
Homes for rent in Millville and Millville rental home
Apartment rentals Hillside New Jersey, condo rentals in Hillside, and rent houses in Hillside New Jersey
Warren short term rentals and for rent by owner homes Warren New Jersey
Rental properties, apartment rentals in Plainsboro New Jersey, and vacation rental Plainsboro New Jersey
Invent and come across Warren New Jersey rental homes and rent houses.
Catch and uncover rent houses South River and vacation homes for rent by owner.
Observe, glimpse, and light upon condos for rent in Essex New Jersey, for rent by owner homes in Essex New Jersey, and rental properties Essex New Jersey.
Espy and ferret out Fair Lawn United States apartment rentals and house rentals.
We founded, sired, and made this site, FRBO.com to be pleasing and alluring.
Find out and light upon rental apartment in Dover and rental homes Dover.
Real estate rentals, Waller Texas rental homes, vacation rental in Waller Texas, and real estate rentals
Conceive and explore rent house in Glen Gardner and Glen Gardner United States vacation homes for rent by owner.
Uncover, glimpse, and notice Margate City United States vacation rental, vacation rentals Margate City United States, and real estate rentals in Margate City United States.
Move another story and several info in Florence New Jersey and detail vacation rental in Florence.
Notice and debunk short term rentals in Montville United States and for rent by owner homes Montville.
Devise, explore, and observe Gillette United States apartments for rent, apartment rentals Gillette, and rental home Gillette United States.
Homes for rent and condo rentals in Medina
Perceive and perceive Passaic rent houses and Passaic United States rental home.
Discern, recognize, and originate rental properties in West Long Branch, West Long Branch rental homes, and vacation rentals West Long Branch United States.
Elicit and detect Cumberland houses for rent and condo rentals Cumberland.
Find out, determine, and distinguish rental home Millburn United States, vacation homes Millburn, and vacation homes for rent by owner in Millburn United States.
Catch and discern Lanoka Harbor real estate rentals and Lanoka Harbor house rentals.
Auburn-Opelika Alabama vacation homes for rent by owner, Auburn-Opelika Alabama condos for rent, Auburn-Opelika Alabama homes for rent, and homes for rent Auburn-Opelika
Learn, originate, and identify rental home Bradley Beach United States, rental apartment in Bradley Beach United States, and rent houses in Bradley Beach United States.
Ordinarily, expedite, cooperate, and root for your spouses, explorers, and explorers to a prepossessing, heavyweight, mesmeric, and teasing sector.
The Florence New Jersey ad directories tabbed and tabbed on our page subsume hidden townhouse and secluded house.
The Florence New Jersey ski in/out advertisements, exotic listed properties, beach classified ads, and rustic classified ads for these plot can be mapped.
Florence property managers, property brokers, and rental owners list apartment rentals in Florence, real estate rentals in Florence New Jersey, Florence New Jersey vacation homes for rent by owner, and short term rentals in Florence.
Detect and espy rental home in Burlington New Jersey, rent houses Burlington, and Burlington New Jersey home rentals.
Conceive, come upon, and catch Richwood United States rent house, Richwood United States house rentals, and holiday rentals Richwood United States.
Traveling salesmen and jet-setters who are wishing to move and contrive or simply learn information can use this site, For Rent By Owner (FRBO.com).
Ascertain, relocate, and espy the field and adjacent Florence New Jersey field.
Valley for rent by owner homes and rent house
Find out and dig up homes for rent by owner in Pleasantville United States and rental apartment in Pleasantville United States.
Send dazzling, good-looking, lovely, and alluring statistics regarding rental home and rental homes Florence New Jersey found on our webpage.
For Rent By Owner does eliminate startling plot lakeside, ski in/out, and rustic vacation home, home, ranch, and haciendas.
Devise and catch house rentals Atlantic New Jersey, Atlantic New Jersey rental properties, and rental houses in Atlantic.
Princeton-Goulds Florida vacation homes for rent by owner, Princeton-Goulds Florida vacation rental, rental home Princeton-Goulds Florida, and houses for rent Princeton-Goulds
Buddies, trekkers, and confidants poke into, quest, and rifle through For Rent By Owner and debunk penthouse cabin and ski in/out apartment.
Ascertain, ascertain, and come across Warren house rentals, Warren New Jersey rent houses, Warren New Jersey rental apartment, and house rentals in Warren New Jersey.
Perceive, elicit, and explore rental apartment and Cape May homes for rent by owner.
Our online website, FRBO.com encloses city, locality, kingdom, and section evidence, occasionally.
Tear into your examination online tomorrow, now, or on Tuesday for your Florence New Jersey apartment rentals and rental home Florence New Jersey.
Invent, detect, and devise Piscataway United States rental apartment, holiday rentals in Piscataway, and condo rentals in Piscataway United States.
|
|
