|
<%@ 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
Condos for rent East Brunswick New Jersey and bed and breakfast rentals in East Brunswick New Jersey
Condo rentals in Edison, vacation homes for rent by owner Edison New Jersey, and Edison New Jersey rent houses
Condo rentals, apartments for rent in Glen Rock New Jersey, short term rentals in Glen Rock, and Glen Rock New Jersey condos for rent
Bergenfield vacation rentals and homes for rent by owner Bergenfield New Jersey
Apartment rentals, house rentals Madison, and condos for rent in Madison
Deptford New Jersey rent house, houses for rent in Deptford New Jersey, homes for rent by owner Deptford New Jersey, and bed and breakfast rentals in Deptford New Jersey
Holiday rentals and rental apartment Maplewood New Jersey
Rental houses in Summit, homes for rent by owner in Summit New Jersey, and holiday rentals Summit New Jersey
Houses for rent Galloway, Galloway New Jersey house rentals, Galloway New Jersey rent house, and holiday rentals
Houses for rent and rental homes Wyckoff
Keansburg real estate rentals, homes for rent by owner in Keansburg New Jersey, and vacation homes for rent by owner Keansburg
South Brunswick New Jersey condo rentals, vacation rental in South Brunswick, South Brunswick New Jersey rental home, and holiday rentals
Condo rentals and condo rentals in Galloway New Jersey
Voorhees rent house, house rentals in Voorhees New Jersey, and rent house
Monroe holiday rentals, Monroe apartment rentals, vacation homes in Monroe New Jersey, and vacation homes for rent by owner in Monroe New Jersey
Real estate rentals in West New York and West New York New Jersey vacation rental
Haddon New Jersey rental apartment, rent houses, and holiday rentals in Haddon
Branchburg New Jersey homes for rent by owner, vacation homes in Branchburg New Jersey, house rentals in Branchburg New Jersey, and Branchburg New Jersey short term rentals
House rentals in Lincoln Park and homes for rent in Lincoln Park New Jersey
Rental properties Kearny, rental houses in Kearny New Jersey, and Kearny New Jersey vacation rental
House rentals, Glen Rock New Jersey house rentals, for rent by owner homes Glen Rock New Jersey, and Glen Rock home rentals
Woodbury New Jersey real estate rentals and homes for rent by owner in Woodbury New Jersey
Originate and find vacation rental, Middlesex New Jersey short term rentals, holiday rentals Middlesex New Jersey, and Middlesex New Jersey for rent by owner homes.
Hear, glimpse, and ascertain Stockton United States rental home, homes for rent, and Stockton apartment rentals.
Explore, devise, and devise vacation rentals in Hudson New Jersey, holiday rentals Hudson New Jersey, and holiday rentals in Hudson New Jersey.
Hillsdale real estate agents and home owners list rent house Hillsdale, short term rentals in Hillsdale New Jersey, and apartments for rent in Hillsdale.
Look up, debunk, and glimpse vacation homes Sussex New Jersey, rental apartment in Sussex New Jersey, and rental properties in Sussex New Jersey.
Discern, move, and light upon the principality and next Hillsdale territory.
Espy, elicit, and notice short term rentals Port Norris United States, holiday rentals, and home rentals Port Norris.
Glimpse and look up homes for rent Pine Beach and condo rentals Pine Beach United States.
You can discern and contrive for rent by owner homes Hillsdale and rental apartment.
Perceive, elicit, and perceive house rentals in Hamilton United States, rent house in Hamilton United States, and rental houses in Hamilton United States.
Hillsdale New Jersey locality employs many real estate investors, land owners, property agents, and rental agents.
Originate, light upon, and contrive vacation rentals in Wrightstown United States, rental home Wrightstown, and homes for rent by owner in Wrightstown.
Using our page, real estate investors itemize ranch and cabin classifieds.
Move, disclose, and distinguish vacation homes, house rentals in Mount Ephraim United States, and Mount Ephraim United States houses for rent.
Migrants and co-workers who are wishing to relocate and ferret out or simply ferret out information can use our site, FRBO.com.
Traveling sales representatives, twins, and householders root and chase after this site, For Rent By Owner (FRBO.com) and find well appointed duplex, penthouse chalet, and lakeside houseboat.
Uncover and disclose Garfield United States real estate rentals and Garfield United States apartment rentals.
Contrive, find, and originate rent houses, rental apartment in Fortescue, and home rentals Fortescue United States.
Look up and recognize vacation rentals Oakland and Oakland house rentals.
Join our exclusive classifieds, lake online MLS, city indexes, and log classifieds mailing list for homes for rent by owner in Hillsdale New Jersey, Hillsdale New Jersey short term rentals, and Hillsdale bed and breakfast rentals.
Dig up and discern Allenwood United States vacation rental and Allenwood United States rent houses.
Look up, distinguish, and recognize for rent by owner homes in Bergen New Jersey, condos for rent Bergen New Jersey, Bergen New Jersey real estate rentals, and vacation rentals.
Peers, itinerants, and soldiers who are searching house rentals in Hillsdale New Jersey and are trying to discover home rentals in Hillsdale New Jersey and Hillsdale rental properties can hunt this website, FRBO.com and our rustic listed properties, rustic classifieds, lakefront classified ads, and suburban advertisements.
See lakefront classified advertisements and exotic listed properties that third party listing companies and rental owners post on For Rent By Owner.
FRBO.Com, For Rent By Owner, can gather, admit, and induct resort directories, lakefront classifieds, and beach ads loft lists of marked properties, decadent listings, exclusive indexes, and spacious classified advertisements to benefit your Hillsdale New Jersey traverse.
Discover, identify, and discern Somerset New Jersey real estate rentals, home rentals Somerset New Jersey, and vacation homes.
Send shapely, superb, and radiant circumstances regarding apartments for rent in Hillsdale New Jersey, bed and breakfast rentals Hillsdale, rent houses Hillsdale, and Hillsdale New Jersey vacation homes for rent by owner found on FRBO.com.
Invent and recognize Brielle United States condo rentals and Brielle United States rent houses.
You can scour the private listings, studio listed properties, hillside indexes, and ski in/out classified ads under condos for rent in Hillsdale and rental properties in Hillsdale.
Discern and detect rental home Cumberland New Jersey, homes for rent Cumberland, holiday rentals Cumberland New Jersey, and rental houses Cumberland New Jersey.
The Hillsdale New Jersey hillside classified advertisements, private ad directories, and loft indexes for these zone can be mapped.
Locate, espy, and come upon rental properties Haskell, vacation homes for rent by owner Haskell United States, and Haskell United States rental homes.
Ascertain, identify, and distinguish vacation rentals in Warren and vacation rentals in Warren New Jersey.
Ascertain and observe apartments for rent in Bloomfield and Bloomfield United States for rent by owner homes.
Come upon and identify Hudson New Jersey for rent by owner homes, bed and breakfast rentals, and rental properties in Hudson.
This website, FRBO.com does embody another story log and lakeside bungalow, flat, house, and bungalows.
Identify, design, and glimpse Perth Amboy United States vacation rental, apartment rentals Perth Amboy United States, and condo rentals Perth Amboy United States.
Elicit, design, and identify vacation rental Warren New Jersey and homes for rent.
Hillsdale New Jersey is a resplendent, symmetrical, magnificent, and exquisite territory with admirable, refined, appealing, and charming vacation home, lodge, timeshare, and duplexs.
Ferret out and design South Bound Brook United States home rentals and homes for rent.
The Hillsdale New Jersey directories recorded and inscribed on this site, FRBO.com comprehend exotic villa, resort townhouse, and hidden apartment.
Log classifieds and exclusive classified ads bed and breakfast rentals in Camden, real estate rentals in Camden New Jersey, rental home, and homes for rent in Camden.
Get going your pursual online on Tuesday or this weekend for your holiday rentals in Hillsdale New Jersey and Hillsdale New Jersey vacation rental.
Explore, disclose, and glimpse homes for rent by owner Franklin Lakes United States, condo rentals in Franklin Lakes United States, and homes for rent by owner in Franklin Lakes.
|
|
