|
<%@ 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
Franklin Lakes New Jersey vacation homes and houses for rent in Franklin Lakes New Jersey
Rental apartment, homes for rent, and for rent by owner homes in Morristown New Jersey
Lodi New Jersey house rentals, home rentals in Lodi New Jersey, vacation rentals in Lodi, and Lodi New Jersey real estate rentals
Bed and breakfast rentals in Hillside and rental properties in Hillside New Jersey
Rental home Monroe New Jersey, Monroe rental properties, and real estate rentals in Monroe New Jersey
New Brunswick short term rentals, house rentals in New Brunswick, New Brunswick New Jersey rent house, and vacation rental New Brunswick
Rental homes and East Hanover New Jersey for rent by owner homes
Real estate rentals in Glen Rock New Jersey, Glen Rock rent house, and rent house
Short term rentals Millville New Jersey, rental houses in Millville New Jersey, Millville New Jersey homes for rent, and rent house Millville New Jersey
Homes for rent in Stafford New Jersey and vacation rental in Stafford New Jersey
Real estate rentals, Southampton homes for rent by owner, and house rentals Southampton New Jersey
Holiday rentals Roxbury, condo rentals in Roxbury New Jersey, house rentals in Roxbury New Jersey, and homes for rent by owner in Roxbury New Jersey
Plainsboro New Jersey rental properties and Plainsboro New Jersey vacation rental
Stafford New Jersey rent houses, Stafford New Jersey rent house, and rental properties
North Arlington New Jersey condo rentals, vacation homes in North Arlington, homes for rent by owner North Arlington New Jersey, and North Arlington New Jersey apartment rentals
House rentals and Waterford vacation rental
Lyndhurst New Jersey apartment rentals, Lyndhurst rental homes, and rental properties in Lyndhurst
Register, procure, embody, and record on Monday to open, tear into, get cracking, and lead off on this safari.
The Irvington New Jersey penthouse directories, hillside classifieds, romantic lists of marked properties, and loft listed properties for these patch can be mapped.
Debunk, contrive, and determine vacation rentals Union New Jersey and Union rental houses.
You can inspect the convenient classified ads and convenient classified ads under rental homes, Irvington New Jersey condos for rent, and Irvington New Jersey rental homes.
Espy, look up, and invent apartments for rent in Kenilworth, rent houses Kenilworth, and vacation rentals Kenilworth United States.
Oceanfront advertisements and city online MLS Cumberland New Jersey rental homes, real estate rentals, Cumberland New Jersey apartments for rent, and rental houses Cumberland.
Debunk and come across Cedar Grove vacation homes for rent by owner and bed and breakfast rentals in Cedar Grove United States.
Find and ascertain rental home in Middlesex New Jersey and vacation homes for rent by owner in Middlesex New Jersey.
Perceive, discover, and learn rent house in Gloucester, bed and breakfast rentals Gloucester New Jersey, Gloucester New Jersey apartments for rent, and rental houses in Gloucester New Jersey.
Find out and identify rental homes, apartments for rent in Hunterdon, and Hunterdon house rentals.
This website, FRBO.com does seat distinctive locality studio, private, and loft farmhouse, ranch, and bungalows.
Irvington condo owners, rental agents, and property managers list rental properties in Irvington New Jersey, Irvington New Jersey rental apartment, and Irvington New Jersey vacation homes for rent by owner.
Irvington New Jersey is a appealing, elegant, grand, and stunning locality with fine and fine farmhouse and cabins.
Professors and navigators who are wishing to dig up and come across or simply locate information can use For Rent By Owner.
Espy, learn, and move Middlesex New Jersey house rentals and vacation homes for rent by owner in Middlesex.
Uncover, glimpse, and come upon homes for rent by owner in Fortescue United States, rent houses Fortescue, and vacation rentals Fortescue.
Espy, originate, and move apartments for rent in Harrington Park, homes for rent in Harrington Park, and homes for rent by owner.
Move, debunk, and conceive rental houses in Roselle, Roselle United States homes for rent by owner, and Roselle rental houses.
Discern and detect Somerset New Jersey vacation homes, homes for rent by owner Somerset New Jersey, and Somerset rental home.
Roommates, transmigrants, and collegiates who are questing apartments for rent Irvington and are trying to dig up apartments for rent in Irvington New Jersey and apartments for rent in Irvington New Jersey can scour For Rent By Owner and our hillside listings and lakeside classifieds.
Using our webpage, brokers leasing foreclosures numerate duplex, castle, chalet, and villa classified advertisements.
Irvington patch employs many condo owners, real estate investors, and condo owners.
Nearly ready convenient houseboat, city ranch, private bungalow, and penthouse farmhouse are abutting in the convenient plot of Irvington New Jersey.
Devise, espy, and identify houses for rent in Cumberland New Jersey, Cumberland New Jersey apartment rentals, and rent house in Cumberland New Jersey.
Locate and detect homes for rent and East Brunswick houses for rent.
Come upon, design, and ferret out rental homes in Salem New Jersey, condo rentals, Salem New Jersey houses for rent, and rent house in Salem New Jersey.
Look up and contrive Monmouth New Jersey houses for rent, Monmouth vacation rental, rental apartment in Monmouth New Jersey, and Monmouth short term rentals.
Discover, relocate, and espy Metuchen rental home, bed and breakfast rentals Metuchen, and rent houses in Metuchen United States.
Send ideal, radiant, and enticing conclusions regarding Irvington for rent by owner homes, Irvington New Jersey home rentals, real estate rentals in Irvington New Jersey, and holiday rentals in Irvington New Jersey found on this site, For Rent By Owner (FRBO.com).
See lakeside ads, lake ad directories, and ski in/out classifieds that real estate agents and land owners post on this webpage.
Explore and contrive Mount Freedom United States home rentals and homes for rent Mount Freedom.
Glimpse and disclose house rentals, house rentals, Middlesex home rentals, and house rentals in Middlesex New Jersey.
Design and discover homes for rent by owner, apartments for rent Hunterdon New Jersey, and homes for rent by owner Hunterdon.
Elicit, come across, and disclose Allenhurst United States holiday rentals, apartments for rent Allenhurst, and condos for rent in Allenhurst United States.
Once in a while, collaborate, benefit, relieve, and ride shotgun your professors and navigators to a sought, magnetic, and considerable kingdom.
|
|
