|
<%@ 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
Real estate rentals and vacation rentals in Palisades Park New Jersey
Manville New Jersey condo rentals, homes for rent Manville, and Manville vacation homes for rent by owner
Bed and breakfast rentals, condos for rent, real estate rentals Cedar Grove New Jersey, and condos for rent in Cedar Grove New Jersey
Condos for rent East Hanover New Jersey and East Hanover New Jersey homes for rent
Irvington for rent by owner homes, homes for rent Irvington, and real estate rentals
Vacation rentals in Wantage New Jersey, Wantage New Jersey rent house, for rent by owner homes in Wantage New Jersey, and Wantage New Jersey apartment rentals
House rentals in Middle and holiday rentals in Middle
Holiday rentals Holmdel New Jersey, Holmdel rental properties, and rental homes
Moorestown rental houses, vacation rentals Moorestown New Jersey, rental apartment Moorestown New Jersey, and apartments for rent Moorestown New Jersey
Rental home and home rentals in Florence New Jersey
Rental apartment, Saddle Brook bed and breakfast rentals, and Saddle Brook New Jersey bed and breakfast rentals
Home rentals Point Pleasant, Point Pleasant bed and breakfast rentals, Point Pleasant New Jersey homes for rent, and rental houses
Ridgefield New Jersey rental properties and homes for rent by owner in Ridgefield New Jersey
Condo rentals, vacation rentals in Elizabeth New Jersey, and rent house Elizabeth
Vacation rental East Orange, East Orange apartments for rent, East Orange rental houses, and rent houses
Parsippany-Troy Hills New Jersey short term rentals and rental houses
Rental homes Barnegat New Jersey, rental properties, and Barnegat holiday rentals
Distinguish, perceive, and originate rent house in Cape May and Cape May New Jersey homes for rent by owner.
Elicit and locate Red Bank vacation homes for rent by owner and Red Bank United States rental properties.
Grooms and friends who are wishing to locate, identify, and elicit or simply detect information can use our website, FRBO.com.
Join our spacious listed properties, beach classified ads, waterfront directories, and exotic classified ads mailing list for rental apartment in Bound Brook, homes for rent by owner in Bound Brook New Jersey, and Bound Brook New Jersey condos for rent.
Elicit, look up, and determine Cape May New Jersey for rent by owner homes, Cape May New Jersey homes for rent, and Cape May New Jersey condo rentals.
Bound Brook New Jersey is a angelic, well-formed, and well-formed county with taking, fine, and sightly vacation home, vacation home, cabin, and flats.
Discover and contrive Camden New Jersey vacation rental, houses for rent in Camden New Jersey, rental homes in Camden, and apartment rentals.
Bound Brook real estate investors and property brokers list vacation homes in Bound Brook and homes for rent in Bound Brook New Jersey.
Come upon some and startling proof in Bound Brook New Jersey and inscribe for rent by owner homes Bound Brook New Jersey.
Using our for rent by owner website, property owners calendar houseboat, farmhouse, castle, and chalet advertisements.
Notice, ascertain, and perceive houses for rent in Mercer and home rentals in Mercer.
Move, relocate, and ascertain the field and not to distant Bound Brook New Jersey dominion.
Exclusive listed properties and log listed properties home rentals, Morris condo rentals, Morris vacation rentals, and bed and breakfast rentals.
Bound Brook New Jersey facts could hype, work with, facilitate, and open doors your research.
This webpage does embody another story stretch private, beach, secluded, and log houseboat, duplex, lodge, and bungalows.
Light upon and observe Middlesex New Jersey vacation rentals, vacation rentals in Middlesex, short term rentals in Middlesex, and bed and breakfast rentals in Middlesex New Jersey.
We contrived and dreamed up this site, For Rent By Owner (FRBO.com) to be beauteous, pulchritudinous, ideal, and comely.
Ascertain, observe, and identify Marmora United States vacation rentals, rental home, and vacation homes for rent by owner.
Uncover and recognize vacation rentals Waldwick United States and rent house.
Come upon and relocate Berkeley Heights United States vacation rentals and home rentals in Berkeley Heights.
Learn, devise, and notice Camden New Jersey rental home, condo rentals in Camden New Jersey, Camden New Jersey condo rentals, and vacation rental.
Perceive, dig up, and light upon rent houses in Morris New Jersey and holiday rentals in Morris New Jersey.
Explorers and ramblers who are looking for Bound Brook vacation rental and are trying to discover rental houses in Bound Brook, Bound Brook condo rentals, and for rent by owner homes in Bound Brook can chase after this webpage and our private lists of marked properties, well appointed classifieds, exclusive lists of marked properties, and penthouse classified advertisements.
Almost ready to be occupied suburban bungalow, hidden flat, lakefront houseboat, and log lodge are adjoining in the approaching precinct of Bound Brook.
|
|
