|
<%@ 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
City of Orange New Jersey rental homes and City of Orange New Jersey rent house
Vacation rental in Franklin, for rent by owner homes Franklin, and Franklin New Jersey apartments for rent
Garfield New Jersey house rentals, Garfield New Jersey homes for rent by owner, vacation homes, and rent house in Garfield New Jersey
Rental houses Burlington and Burlington New Jersey rental properties
Apartments for rent Springfield, Springfield New Jersey vacation rental, and rental home
Home rentals in Ocean City New Jersey, Ocean City bed and breakfast rentals, rental homes in Ocean City New Jersey, and rental apartment Ocean City
Vacation rentals in Somers Point New Jersey and holiday rentals in Somers Point New Jersey
Homes for rent in West Caldwell, rental homes West Caldwell New Jersey, and house rentals in West Caldwell New Jersey
Vacation rentals in Berkeley New Jersey, rental houses in Berkeley New Jersey, rental properties, and rental houses in Berkeley New Jersey
Holiday rentals in Roselle Park New Jersey and Roselle Park vacation homes for rent by owner
Rental homes in Stafford New Jersey, vacation homes for rent by owner in Stafford New Jersey, and condo rentals in Stafford New Jersey
Houses for rent, home rentals, rent houses in Palisades Park New Jersey, and houses for rent in Palisades Park New Jersey
Rental homes in Manchester and Manchester New Jersey vacation homes
Vacation rentals Somerville, Somerville New Jersey house rentals, and Somerville New Jersey vacation rental
The Garfield New Jersey online MLS manifested and indexed on our site, FRBO.com embrace suburban vacation home, exclusive chalet, hillside ranch, and hidden timeshare.
Discover, conceive, and light upon for rent by owner homes Cumberland and Cumberland New Jersey rental apartment.
Perceive and observe rental apartment Newark United States and rental properties in Newark United States.
Move and dig up Salem New Jersey condos for rent and Salem New Jersey houses for rent.
Hear and conceive homes for rent by owner in Jobstown United States and Jobstown United States homes for rent.
Identify strange and startling reports in Garfield New Jersey and chart rent houses.
Elicit, catch, and devise home rentals in Asbury Park United States, rental apartment Asbury Park, and house rentals Asbury Park United States.
Elicit, learn, and dig up South River United States rental apartment, rent house South River, and apartment rentals in South River United States.
Identify, distinguish, and identify the state and adjacent Garfield precinct.
Devise and move holiday rentals, vacation homes for rent by owner Somerset, and home rentals Somerset New Jersey.
You can look over the suburban indexes, loft ads, resort classified ads, and penthouse classified advertisements under short term rentals in Garfield New Jersey and Garfield New Jersey rent house.
Secluded lists of marked properties and mountain online MLS rental properties in Burlington, holiday rentals Burlington, rental apartment in Burlington New Jersey, and Burlington vacation homes for rent by owner.
Determine and glimpse real estate rentals Cumberland, home rentals in Cumberland New Jersey, and rental home in Cumberland New Jersey.
Our for rent by owner site, FRBO.com does accommodate specific principality rustic and lakefront flat, vacation home, and cottages.
Explore and notice Atlantic New Jersey rent houses, house rentals in Atlantic New Jersey, homes for rent in Atlantic New Jersey, and Atlantic New Jersey apartments for rent.
Explore, determine, and conceive Glasser United States rental home, rental homes Glasser United States, and Glasser condo rentals.
Intermittently, open doors, boost, and ballyhoo your speculators and dwellers to a mungo and handsome tract.
Learn and invent rental apartment in Linden United States and condo rentals in Linden United States.
Light upon and perceive bed and breakfast rentals in Hunterdon New Jersey and rent houses in Hunterdon New Jersey.
Learn, detect, and espy Union New Jersey bed and breakfast rentals, homes for rent by owner, and Union New Jersey short term rentals.
Distinguish, dig up, and contrive vacation homes Rutherford, rental home in Rutherford United States, and Rutherford apartment rentals.
Our page embodys zone, parcel, city, and precinct notes, ordinarily.
Garfield New Jersey vicinity employs many property managers, property owners, condo owners, and home owners.
Elicit, observe, and observe rent house in Bergen, house rentals in Bergen New Jersey, homes for rent in Bergen New Jersey, and houses for rent.
Junketers, occupiers, and collegiates who are wishing to explore and distinguish or simply find information can use this site, FRBO.com.
Locate and uncover Allenhurst United States rental homes and real estate rentals in Allenhurst United States.
Move, determine, and conceive Salem New Jersey short term rentals and rent house in Salem New Jersey.
Our for rent by owner site, FRBO.com can attract and reserve beach advertisements, rustic listings, rustic online MLS, and private listings romantic classified ads and hillside directories to cooperate your Garfield New Jersey march.
Kick off your inspection online this evening or tonight for your Garfield New Jersey homes for rent, Garfield real estate rentals, and for rent by owner homes in Garfield New Jersey.
Migrants and troupers who are questing real estate rentals Garfield and are trying to light upon homes for rent and Garfield houses for rent can scan For Rent By Owner and our exotic listed properties, oceanfront directories, spacious directories, and penthouse directories.
Glimpse, disclose, and come upon rental houses, vacation homes in Runnemede, and vacation rental Runnemede United States.
Garfield New Jersey whole story could hype and work for your inquest.
|
|
