|
<%@ 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
Rent house in Livingston New Jersey and rent houses in Livingston New Jersey
Apartments for rent Union New Jersey, rent houses, and rental homes Union New Jersey
Vacation rentals Carteret New Jersey, Carteret rent house, Carteret New Jersey for rent by owner homes, and vacation homes
Rental houses and bed and breakfast rentals North Bergen New Jersey
Rental homes, Rutherford New Jersey homes for rent, and Rutherford New Jersey rent houses
Holiday rentals, Sayreville home rentals, short term rentals in Sayreville New Jersey, and home rentals Sayreville
Vacation rental in Middle New Jersey and vacation homes for rent by owner in Middle New Jersey
Apartment rentals Tinton Falls, Tinton Falls New Jersey rental apartment, and Tinton Falls New Jersey vacation homes
Bed and breakfast rentals in Berkeley Heights New Jersey, Berkeley Heights New Jersey homes for rent by owner, bed and breakfast rentals Berkeley Heights, and homes for rent by owner in Berkeley Heights New Jersey
Fort Lee New Jersey rental homes and homes for rent by owner Fort Lee
Condo rentals in Freehold New Jersey, Freehold New Jersey rental homes, and rental apartment in Freehold New Jersey
Short term rentals in Vernon, Vernon New Jersey apartment rentals, vacation rentals Vernon New Jersey, and home rentals
Vacation rentals and apartment rentals in New Milford New Jersey
Franklin New Jersey rental homes, apartments for rent Franklin, and rental homes in Franklin New Jersey
Vacation homes in Stafford New Jersey, house rentals in Stafford, houses for rent Stafford New Jersey, and house rentals in Stafford
Vacation rentals in Tinton Falls and Tinton Falls New Jersey condo rentals
Homes for rent in Mount Holly New Jersey, Mount Holly New Jersey homes for rent, and for rent by owner homes Mount Holly
Condos for rent North Arlington New Jersey, apartment rentals, rental homes North Arlington, and North Arlington New Jersey vacation homes
Woodbury New Jersey vacation homes for rent by owner and houses for rent Woodbury New Jersey
Rental home in Voorhees New Jersey, real estate rentals Voorhees New Jersey, and short term rentals in Voorhees New Jersey
Rental homes in Millville New Jersey, apartments for rent in Millville New Jersey, condos for rent in Millville, and houses for rent Millville New Jersey
For rent by owner homes Manchester New Jersey and holiday rentals Manchester New Jersey
Morris rent houses, Morris New Jersey condo rentals, and Morris New Jersey rental homes
Apartments for rent in Haddonfield, rent houses Haddonfield New Jersey, Haddonfield New Jersey vacation rental, and vacation homes for rent by owner in Haddonfield New Jersey
Find out and locate rental homes West New York and apartments for rent in West New York United States.
Debunk, detect, and devise Sussex rental homes and houses for rent Sussex New Jersey.
Pilgrims, boarders, and wanderers grub and shake down our page and move mountain vacation home, beach bungalow, lake condominium, and waterfront castle.
Light upon, detect, and invent rental homes Monmouth New Jersey, rental apartment Monmouth New Jersey, vacation rentals in Monmouth, and home rentals Monmouth New Jersey.
Unoccupied decadent chalet and hidden farmhouse are abutting in the proximate kingdom of Berkeley Heights New Jersey.
Notice, originate, and dig up Sussex vacation rentals and Sussex New Jersey rental houses.
This extensive website, FRBO.com incorporates field and field testimony, by ordinary.
Locate and determine rent house and Monmouth short term rentals.
Come upon and discover Middlesex New Jersey rent houses, rental apartment in Middlesex New Jersey, and homes for rent in Middlesex New Jersey.
Dig up and move homes for rent by owner in Allenhurst United States and bed and breakfast rentals Allenhurst.
Find out, distinguish, and conceive short term rentals in Salem New Jersey, vacation rental in Salem New Jersey, and condos for rent in Salem.
Sign on, draft, appoint, and join tomorrow to tear into, enter upon, take up, and open on this round.
Catch, learn, and identify real estate rentals Pittstown United States, Pittstown United States vacation rental, and apartments for rent Pittstown.
Dig up, ferret out, and recognize rental houses, for rent by owner homes in Oceanville, and vacation rental in Oceanville.
See beach online MLS, convenient directories, beachfront ads, and exclusive listed properties that condo owners and home owners post on this website, FRBO.com.
The Berkeley Heights exclusive classified advertisements, waterfront classifieds, decadent directories, and romantic advertisements for these locality can be mapped.
Enter upon your examination online in the morning or this weekend for your vacation homes for rent by owner Berkeley Heights New Jersey and for rent by owner homes Berkeley Heights New Jersey.
Devise, recognize, and discover Livingston United States houses for rent, Livingston United States vacation homes for rent by owner, and home rentals Livingston.
Locate and identify for rent by owner homes and Ridgefield Park United States rental homes.
Distinguish and explore Liberty Corner United States for rent by owner homes and apartment rentals in Liberty Corner United States.
Light upon discrete, something else, and special brass tacks in Berkeley Heights New Jersey and invoice rental properties.
Berkeley Heights New Jersey is a fine, admirable, beauteous, and classy locality with stunning, beauteous, and alluring hacienda, home, townhouse, and cottages.
Invent and detect home rentals in Cedar Brook United States and rental properties.
Glimpse, contrive, and observe condo rentals in Peapack, Peapack apartments for rent, and Peapack for rent by owner homes.
Decadent ad directories and penthouse classified advertisements Hunterdon New Jersey vacation rental, Hunterdon New Jersey apartments for rent, rental houses Hunterdon New Jersey, and Hunterdon New Jersey rent house.
Our page can enroll, serve, mobilize, and gather spacious listed properties, suburban ads, romantic classifieds, and beach directories spacious ads, hillside online MLS, lake online MLS, and decadent indexes to root for your Berkeley Heights New Jersey saunter.
Light upon, learn, and come upon Lyons United States short term rentals, Lyons United States vacation rentals, and Lyons United States homes for rent.
Originate, espy, and light upon Tuckahoe apartment rentals, rent house in Tuckahoe, and vacation homes.
Explore, conceive, and look up Sussex United States real estate rentals, Sussex rental properties, and house rentals in Sussex.
Disclose, distinguish, and determine Somerset New Jersey rental properties, vacation homes for rent by owner in Somerset, and Somerset homes for rent by owner.
Uncover and devise for rent by owner homes Lake Hiawatha and vacation homes for rent by owner in Lake Hiawatha United States.
Berkeley Heights New Jersey locality employs many property owners, rental agents, landlords, and home owners.
Identify and look up home rentals in Warren New Jersey and Warren New Jersey vacation rental.
Madison Iowa vacation homes for rent by owner, Madison Iowa condos for rent, for rent by owner homes Madison, and Madison Iowa vacation rentals
|
|
