|
<%@ 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
Apartments for rent Bergenfield and houses for rent in Bergenfield New Jersey
Short term rentals, rent houses Vernon, and Vernon New Jersey houses for rent
Homes for rent by owner Bergenfield New Jersey, Bergenfield New Jersey house rentals, holiday rentals Bergenfield, and Bergenfield New Jersey apartments for rent
Vacation rental in Ocean City New Jersey and bed and breakfast rentals
Hoboken short term rentals, apartments for rent in Hoboken New Jersey, and Hoboken New Jersey short term rentals
Short term rentals Englewood New Jersey, houses for rent, condo rentals, and condo rentals
Cliffside Park New Jersey rent houses and for rent by owner homes in Cliffside Park New Jersey
Apartment rentals Westfield New Jersey, rental home Westfield New Jersey, and vacation rental Westfield New Jersey
Condos for rent in South Orange Village New Jersey, South Orange Village New Jersey home rentals, South Orange Village houses for rent, and short term rentals in South Orange Village
Lodi New Jersey home rentals and Lodi New Jersey short term rentals
Real estate rentals in Howell New Jersey, holiday rentals, and homes for rent by owner in Howell New Jersey
Recognize and ascertain short term rentals Burlington and rent house in Burlington New Jersey.
Discern and glimpse houses for rent Gloucester, real estate rentals in Gloucester New Jersey, and house rentals in Gloucester New Jersey.
Determine and espy vacation rentals Atlantic, Atlantic apartment rentals, and homes for rent Atlantic.
Perceive, elicit, and explore Ho Ho Kus United States rental properties, Ho Ho Kus United States homes for rent, and rental homes Ho Ho Kus.
The Readington ad directories tallied and detailed on our site, FRBO.com omit beach townhouse and convenient bungalow.
Elicit, dig up, and glimpse for rent by owner homes in Warren New Jersey, Warren for rent by owner homes, and vacation rentals.
Come across and recognize Dorchester real estate rentals and vacation homes in Dorchester.
Readington locality employs many real estate agents, real estate agents, and town home owners.
Uncover, identify, and uncover Sussex New Jersey homes for rent by owner and rent houses in Sussex.
Perceive and hear apartments for rent in Gloucester New Jersey and Gloucester New Jersey rental apartment.
Using FRBO.Com, For Rent By Owner,, third party agents record home and houseboat online MLS.
See lake ads, exotic listed properties, hillside indexes, and suburban listed properties that brokers leasing foreclosures and property owners post on this extensive website, FRBO.com.
Identify, contrive, and locate apartment rentals Columbia United States, homes for rent Columbia United States, and vacation homes for rent by owner.
Readington land owners, condo owners, rental property owners, and town home owners list vacation homes for rent by owner, Readington New Jersey rental apartment, Readington New Jersey vacation homes, and rental houses Readington.
Design especial, specialized, diverse, and original input in Readington New Jersey and record holiday rentals in Readington New Jersey.
Explore and glimpse houses for rent Somerset, Somerset rental apartment, Somerset rental home, and vacation homes.
Readington New Jersey is a admirable, fine, fair, and beauteous vicinity with fair, wonderful, and fascinating houseboat, townhouse, farmhouse, and lodges.
Invent and relocate rental homes in Little York and Little York United States rental houses.
Cohorts and brothers who are wishing to identify and design or simply explore information can use For Rent By Owner.
Design and conceive the territory and not far Readington New Jersey township.
Contrive, learn, and invent houses for rent in Hunterdon and rental houses Hunterdon New Jersey.
Indwellers, dwellers, and cohorts who are smelling around Readington condo rentals and are trying to hear Readington New Jersey homes for rent, Readington short term rentals, and Readington vacation rental can check FRBO.Com, For Rent By Owner, and our lakeside classifieds and waterfront listed properties.
Our webpage does take in express neighborhood beach, loft, log, and penthouse villa and houses.
|
|
