|
<%@ 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
Beachwood New Jersey rent house and home rentals in Beachwood New Jersey
Homes for rent by owner Jefferson, apartment rentals in Jefferson, and for rent by owner homes in Jefferson New Jersey
Home rentals in Little Egg Harbor, rental properties in Little Egg Harbor, for rent by owner homes in Little Egg Harbor New Jersey, and rent house in Little Egg Harbor
Vacation rental in Keansburg and vacation rental in Keansburg New Jersey
For rent by owner homes in Rockaway, houses for rent in Rockaway, and houses for rent Rockaway
Home rentals Washington, condo rentals in Washington New Jersey, Washington holiday rentals, and home rentals
Cherry Hill New Jersey condo rentals and Cherry Hill New Jersey vacation homes for rent by owner
Rental properties, apartment rentals Moorestown New Jersey, and Moorestown New Jersey apartment rentals
Pompton Lakes New Jersey vacation rental, vacation homes for rent by owner Pompton Lakes New Jersey, Pompton Lakes New Jersey rental homes, and Pompton Lakes New Jersey bed and breakfast rentals
Holiday rentals in Newark New Jersey and condos for rent Newark New Jersey
Regularly, puff and thump your displaced persons and schoolmates to a bull, whopping, promoted, and winsome area.
Hear and distinguish rental houses and rental apartment.
Detect and identify Hudson New Jersey rental houses, rental homes in Hudson, and rental properties in Hudson.
Discern and look up Ocean New Jersey apartment rentals, Ocean for rent by owner homes, Ocean New Jersey for rent by owner homes, and holiday rentals Ocean.
You can ferret out, notice, and catch for rent by owner homes in Maple Shade New Jersey, for rent by owner homes in Maple Shade New Jersey, and rental houses in Maple Shade.
Hear and detect Salem New Jersey apartment rentals and holiday rentals in Salem New Jersey.
Explore, contrive, and identify Hudson New Jersey apartment rentals and apartments for rent.
Soon to be vacant secluded chalet and beach cabin are near-at-hand in the not faraway vicinity of Maple Shade New Jersey.
Send angelic and resplendent abstracts regarding rental apartment, house rentals in Maple Shade New Jersey, and Maple Shade New Jersey vacation rentals found on FRBO.com.
Take up your expedition online this weekend, on Thursday, or in the next few days for your real estate rentals, Maple Shade New Jersey apartment rentals, and short term rentals.
Sightseers and inhabitants search for and inquire our page and recognize lakefront flat, beach villa, private vacation home, and penthouse cottage.
Using our for rent by owner site, FRBO.com, third party listing companies tab home, farmhouse, cottage, and timeshare ads.
Maple Shade third party listing companies, third party agents, third party agents, and real estate investors list Maple Shade real estate rentals and holiday rentals in Maple Shade New Jersey.
Relocate, glimpse, and devise Union rental properties, vacation homes for rent by owner, and Union New Jersey vacation rental.
City advertisements and studio listings home rentals in Atlantic, house rentals in Atlantic New Jersey, rental apartment Atlantic, and for rent by owner homes in Atlantic New Jersey.
Design and move the tract and adjoining Maple Shade area.
Peers, junketers, and adventurers who are wishing to distinguish, ferret out, and come across or simply discern information can use our site, FRBO.com.
Join our beachfront advertisements and ski in/out classifieds mailing list for rental apartment in Maple Shade and Maple Shade New Jersey vacation rental.
We formulated, authored, and parented this extensive website, FRBO.com to be pulchritudinous and refined.
Move, espy, and discover homes for rent by owner, Hudson New Jersey home rentals, bed and breakfast rentals Hudson New Jersey, and house rentals.
Learn and dig up rental homes in Hazlet United States and vacation homes Hazlet United States.
See secluded classified advertisements, suburban classified ads, and rustic lists of marked properties that property owners and third party agents post on FRBO.Com, For Rent By Owner,.
Our for rent by owner site, FRBO.com does hold extraordinary turf oceanfront, spacious, resort, and romantic villa, duplex, and duplexs.
|
|
