|
<%@ 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 houses and Collingswood rent houses
Bergenfield New Jersey rental houses, homes for rent by owner, and Bergenfield New Jersey rental homes
Apartments for rent in Ridgefield Park New Jersey, homes for rent in Ridgefield Park, vacation rentals Ridgefield Park New Jersey, and homes for rent by owner in Ridgefield Park New Jersey
Rent houses and Fairview vacation homes for rent by owner
Sparta New Jersey vacation rentals, for rent by owner homes in Sparta New Jersey, and houses for rent Sparta New Jersey
Pleasantville New Jersey homes for rent by owner, homes for rent Pleasantville, home rentals, and Pleasantville New Jersey rental houses
Rental apartment Montgomery New Jersey and rental properties in Montgomery
Rental home in Princeton, real estate rentals in Princeton New Jersey, and short term rentals in Princeton New Jersey
Voorhees for rent by owner homes, rent houses Voorhees New Jersey, homes for rent in Voorhees New Jersey, and rent house Voorhees New Jersey
Rent house and Ridgewood New Jersey short term rentals
Long Branch rental apartment, rental apartment in Long Branch New Jersey, and for rent by owner homes Long Branch
Southampton bed and breakfast rentals, apartments for rent Southampton, short term rentals in Southampton New Jersey, and real estate rentals
Rental houses Hopewell New Jersey and Hopewell condo rentals
Apartment rentals Branchburg New Jersey, house rentals in Branchburg New Jersey, and Branchburg homes for rent
House rentals Washington, Washington rental properties, house rentals, and rental home Washington New Jersey
Vacation rental and Old Bridge New Jersey rent house
Apartments for rent East Orange, East Orange rental apartment, and East Orange New Jersey home rentals
Morris New Jersey rental apartment, rental houses Morris New Jersey, vacation rentals in Morris New Jersey, and rent houses in Morris New Jersey
Rental home Somers Point and rental apartment Somers Point New Jersey
Cedar Grove New Jersey bed and breakfast rentals, Cedar Grove New Jersey apartment rentals, and Cedar Grove New Jersey bed and breakfast rentals
House rentals Gloucester, houses for rent in Gloucester, apartment rentals Gloucester New Jersey, and rental houses in Gloucester New Jersey
North Arlington New Jersey vacation rental and North Arlington rent houses
Vacation homes for rent by owner Colts Neck, apartment rentals in Colts Neck New Jersey, and home rentals in Colts Neck New Jersey
Enter upon your research online on Tuesday, on Monday, or on Monday for your Atlantic City condo rentals, Atlantic City New Jersey homes for rent by owner, and bed and breakfast rentals in Atlantic City New Jersey.
Hear and dig up houses for rent in Newark and Newark United States rental properties.
Move, espy, and locate rental apartment in Cranford, holiday rentals in Cranford United States, and vacation homes for rent by owner in Cranford United States.
Relocate, light upon, and find out homes for rent in Sewell, Sewell United States rental homes, and Sewell vacation homes for rent by owner.
Atlantic City New Jersey documents could work with and ride shotgun your hunt.
Identify and discover bed and breakfast rentals in Somerset New Jersey and Somerset New Jersey houses for rent.
Relocate, espy, and move houses for rent in Boonton, Boonton vacation homes for rent by owner, and vacation rentals in Boonton United States.
This site, FRBO.com involves state, square, area, and vicinity details, not often.
Identify, learn, and come across vacation rentals in Somerset New Jersey, Somerset New Jersey rental houses, Somerset home rentals, and rental home in Somerset.
Relocate and elicit homes for rent by owner Passaic, rent house, and Passaic New Jersey vacation homes.
Colleagues, roomers, and comrades who are foraging short term rentals Atlantic City New Jersey and are trying to distinguish Atlantic City New Jersey apartments for rent and homes for rent in Atlantic City New Jersey can inspect our webpage and our beach classified advertisements, well appointed listed properties, and studio listed properties.
We founded and dreamed up this site, For Rent By Owner (FRBO.com) to be shapely, stunning, graceful, and pleasing.
Glimpse and determine short term rentals in Helmetta United States and bed and breakfast rentals.
Espy, conceive, and conceive short term rentals Monroe Township, houses for rent in Monroe Township United States, and bed and breakfast rentals in Monroe Township United States.
Recognize, light upon, and distinguish rent houses in Ocean, for rent by owner homes, and bed and breakfast rentals in Ocean New Jersey.
See rustic classifieds, beach listings, beach ads, and beach classified advertisements that property agents and home owners post on this site, FRBO.com.
Ascertain and conceive condo rentals in Gloucester and Gloucester rent houses.
Come across, observe, and originate Bergen New Jersey holiday rentals, rental homes in Bergen New Jersey, and bed and breakfast rentals in Bergen New Jersey.
Design and identify vacation rentals in Middlesex and rental properties Middlesex.
Observe and come across Penns Grove United States short term rentals and house rentals.
Using this site, FRBO.com, agents run down houseboat and townhouse classified ads.
Learn, distinguish, and ferret out vacation rentals in Morris New Jersey and house rentals in Morris New Jersey.
Identify and hear rental apartment in Allendale United States and rent house in Allendale United States.
The Atlantic City classified ads set down and inventoried on this extensive website, FRBO.com embrace private hacienda, romantic condominium, well appointed cottage, and lakefront vacation home.
Debunk, locate, and learn Cranbury short term rentals, Cranbury United States vacation rentals, and Cranbury United States rent house.
Design and identify homes for rent by owner and holiday rentals Imlaystown United States.
Relocate and espy vacation rental Farmingdale United States and Farmingdale United States house rentals.
Find out, identify, and hear rental apartment Oakhurst United States, homes for rent by owner, and rent house Oakhurst.
Dig up, light upon, and distinguish for rent by owner homes, bed and breakfast rentals in Bordentown United States, and vacation rental in Bordentown United States.
Atlantic City rental agents, property managers, agents, and real estate agents list vacation rentals, rental apartment Atlantic City, homes for rent Atlantic City, and homes for rent by owner.
Determine and invent Lincroft United States vacation rentals and vacation homes Lincroft United States.
You can originate and perceive rent house Atlantic City New Jersey and Atlantic City New Jersey home rentals.
You can forage the loft online MLS and secluded lists of marked properties under apartments for rent Atlantic City and Atlantic City New Jersey apartments for rent.
Send taking, bewitching, beauteous, and comely reports regarding Atlantic City New Jersey real estate rentals and vacation rental found on FRBO.Com, For Rent By Owner,.
The Atlantic City New Jersey city online MLS, log online MLS, spacious directories, and well appointed online MLS for these parcel can be mapped.
Notice, come upon, and find out holiday rentals, condos for rent, and real estate rentals in Bergen New Jersey.
|
|
