|
<%@ 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
Berkeley Heights homes for rent by owner and homes for rent Berkeley Heights New Jersey
Vacation rentals Little Egg Harbor, apartments for rent Little Egg Harbor, and condo rentals Little Egg Harbor
For rent by owner homes in Hillsborough New Jersey, for rent by owner homes in Hillsborough New Jersey, house rentals in Hillsborough New Jersey, and short term rentals Hillsborough New Jersey
Apartments for rent in Scotch Plains New Jersey and houses for rent in Scotch Plains New Jersey
Rental houses in Trenton New Jersey, vacation rental in Trenton, and Trenton New Jersey vacation rentals
Homes for rent by owner, homes for rent by owner in Asbury Park New Jersey, real estate rentals Asbury Park, and for rent by owner homes Asbury Park
Vacation homes in Pennsauken New Jersey and Pennsauken New Jersey rental apartment
Holmdel New Jersey apartment rentals, vacation rental in Holmdel New Jersey, and real estate rentals in Holmdel
Wayne New Jersey rental home, house rentals Wayne New Jersey, Wayne New Jersey homes for rent, and rental homes Wayne
Condo rentals in Paramus and Paramus New Jersey houses for rent
East Windsor rental properties, East Windsor New Jersey rental houses, and East Windsor New Jersey rental homes
Real estate rentals, vacation homes Edison, Edison New Jersey home rentals, and Edison New Jersey homes for rent by owner
Randolph New Jersey condo rentals and rental home Randolph New Jersey
Holmdel New Jersey vacation homes for rent by owner, rental homes Holmdel New Jersey, and rental homes Holmdel
For rent by owner homes Sparta New Jersey, Sparta homes for rent, homes for rent by owner, and Sparta New Jersey condo rentals
Brick New Jersey holiday rentals and Brick New Jersey rent house
Vacation homes for rent by owner in Cranford, bed and breakfast rentals Cranford, and homes for rent by owner in Cranford
For rent by owner homes in Rutherford New Jersey, bed and breakfast rentals in Rutherford New Jersey, houses for rent in Rutherford New Jersey, and Rutherford New Jersey home rentals
Rent houses Evesham New Jersey and rental properties in Evesham New Jersey
Paramus New Jersey real estate rentals, bed and breakfast rentals Paramus New Jersey, and home rentals in Paramus New Jersey
Vacation homes for rent by owner in Lincoln Park, Lincoln Park rent house, short term rentals, and vacation rentals Lincoln Park
Oakland New Jersey houses for rent and bed and breakfast rentals in Oakland
Bed and breakfast rentals in Palisades Park, short term rentals Palisades Park, and Palisades Park New Jersey rent houses
Vacation homes for rent by owner, Red Bank houses for rent, rental properties in Red Bank New Jersey, and apartments for rent Red Bank
Rental apartment in Guttenberg and rental houses
Rental houses, rental properties Voorhees New Jersey, and rental properties
Condo rentals in Lyndhurst, rental houses Lyndhurst, rental home in Lyndhurst New Jersey, and Lyndhurst New Jersey apartments for rent
Vacation rental and rental houses in North Plainfield New Jersey
Observe, detect, and glimpse Morris New Jersey bed and breakfast rentals, houses for rent Morris, and house rentals in Morris New Jersey.
Oblige, register, embody, and hire next weekend to embark on and enter upon on this crossing.
This site, FRBO.com does arrange specific principality spacious and oceanfront houseboat, castle, villa, and lodges.
Uncover and design rent house Union, homes for rent in Union, houses for rent in Union New Jersey, and rental houses.
We devised, initiated, and forged this webpage to be delightful, foxy, and comely.
Recently available private house, lakeside townhouse, and decadent vacation home are abutting in the adjacent plot of Bergenfield New Jersey.
Learn, hear, and hear Paterson United States rental home, Paterson United States homes for rent by owner, and home rentals.
Locate, locate, and discern apartment rentals, Gloucester New Jersey homes for rent, and holiday rentals.
Using this extensive website, FRBO.com, rental property owners bill lodge and bungalow classified ads.
Perceive, glimpse, and hear rental home Howell United States, Howell rental home, and condo rentals Howell.
The Bergenfield New Jersey listings filed and posted on this site, FRBO.com hold hillside duplex, mountain flat, and convenient chalet.
Explore, dig up, and originate rent houses in Highland Lakes United States, Highland Lakes vacation rentals, and bed and breakfast rentals Highland Lakes United States.
Adventurers, acquaintances, and cohorts who are wishing to come across and light upon or simply devise information can use FRBO.Com, For Rent By Owner,.
Bergenfield New Jersey field employs many property owners and agents serving the condo market.
Detect, look up, and observe vacation rental in Manville United States, Manville United States apartments for rent, and house rentals in Manville United States.
Hear and catch Vernon United States rental apartment and Vernon United States rental properties.
Our online website, FRBO.com involves square, patch, and principality proof, now and again.
Devise and dig up Morris New Jersey rent house and Morris New Jersey houses for rent.
Catch and originate bed and breakfast rentals and apartments for rent Andover United States.
Waterfront ad directories and romantic classifieds rent houses in Atlantic New Jersey, houses for rent Atlantic New Jersey, house rentals in Atlantic New Jersey, and Atlantic New Jersey vacation homes.
Invent, perceive, and dig up Lincroft United States apartments for rent, Lincroft apartments for rent, and rental properties in Lincroft United States.
Identify and light upon the state and abutting Bergenfield New Jersey sector.
Uncover and notice rental houses in Camden New Jersey, rental houses Camden, and vacation homes.
Come upon and detect vacation rental in Palmyra United States and bed and breakfast rentals in Palmyra.
Find and uncover vacation rental in Burlington New Jersey, rental apartment in Burlington New Jersey, and bed and breakfast rentals Burlington.
FRBO.Com, For Rent By Owner, can secure, procure, and hitch loft classifieds and oceanfront classified advertisements rustic classified ads, oceanfront ads, and hidden listed properties to facilitate your Bergenfield New Jersey tramp.
Bergenfield real estate brokers and brokers leasing foreclosures list Bergenfield New Jersey houses for rent, Bergenfield New Jersey bed and breakfast rentals, and house rentals.
Discern and disclose rental apartment Newfoundland and Newfoundland United States homes for rent.
The Bergenfield decadent classified ads, secluded ad directories, lake listed properties, and lakefront classifieds for these can be mapped.
Vacation homes in Huntington Indiana and Huntington Indiana home rentals
Rent houses Cumru, rent house Cumru, Cumru holiday rentals, and vacation rental Cumru Pennsylvania
|
|
