|
<%@ 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
Lawrence for rent by owner homes and apartments for rent Lawrence
Mount Holly rental houses, Mount Holly New Jersey short term rentals, and Mount Holly New Jersey homes for rent
House rentals in South Plainfield New Jersey, vacation rentals in South Plainfield New Jersey, rent houses South Plainfield, and rent houses in South Plainfield
Readington New Jersey rental houses and rental home Readington New Jersey
Lacey New Jersey homes for rent, rental properties Lacey New Jersey, and house rentals in Lacey New Jersey
Vacation homes for rent by owner in Morristown, rent house Morristown New Jersey, bed and breakfast rentals in Morristown, and vacation homes Morristown New Jersey
Holiday rentals North Plainfield and rent houses
Secaucus New Jersey homes for rent by owner, Secaucus New Jersey holiday rentals, and rent houses Secaucus
Tinton Falls rent houses, rental home in Tinton Falls New Jersey, vacation homes in Tinton Falls, and homes for rent in Tinton Falls New Jersey
Clinton New Jersey rent house and homes for rent in Clinton
Apartments for rent in Morris New Jersey, rent house in Morris New Jersey, and Morris New Jersey holiday rentals
Rental apartment in North Arlington, apartments for rent North Arlington, North Arlington New Jersey rent houses, and North Arlington New Jersey vacation rentals
Rental properties and apartments for rent in Raritan
Real estate rentals, real estate rentals Phillipsburg New Jersey, and homes for rent in Phillipsburg New Jersey
Holiday rentals, rental home Burlington, vacation rental in Burlington New Jersey, and home rentals in Burlington New Jersey
Homes for rent in Beachwood and Beachwood New Jersey rental houses
Glen Rock New Jersey holiday rentals, Glen Rock New Jersey rent house, and rental apartment Glen Rock New Jersey
Rent houses, Egg Harbor New Jersey homes for rent by owner, Egg Harbor real estate rentals, and Egg Harbor New Jersey condo rentals
House rentals in Warren and rent houses in Warren New Jersey
Rent houses in Woodbridge New Jersey, apartments for rent in Woodbridge, and condos for rent Woodbridge New Jersey
Locate, find, and ferret out Washington United States homes for rent by owner, rental home Washington, and Washington United States holiday rentals.
Explore and catch apartment rentals in Somerset New Jersey, apartments for rent, and holiday rentals in Somerset.
Determine, espy, and perceive Atlantic apartments for rent and rental houses in Atlantic New Jersey.
For Rent By Owner does take in special decadent, resort, lakeside, and lake hacienda and condominiums.
The Paterson New Jersey ad directories charted and spelled out on this site, For Rent By Owner (FRBO.com) incorporate penthouse ranch, lakefront farmhouse, beach ranch, and romantic ranch.
This webpage can appoint, call up, call up, and procure waterfront classifieds and hidden advertisements rustic online MLS, log classified ads, and spacious directories to support your Paterson New Jersey peregrination.
Light upon and explore homes for rent in Monmouth New Jersey and Monmouth New Jersey apartment rentals.
Uncover, explore, and distinguish Park Ridge United States apartments for rent, Park Ridge United States real estate rentals, and vacation rental Park Ridge.
Sporadically, thump and run interference your peers, brothers, and buddies to a stunning, winsome, comely, and praised territory.
Paterson stretch employs many third party agents, third party listing companies, and rental agents.
Uncover, espy, and dig up Monmouth New Jersey rental properties, Monmouth New Jersey bed and breakfast rentals, Monmouth New Jersey condos for rent, and apartment rentals Monmouth.
Record, sign on, incorporate, and get tomorrow evening to take up and originate on this progress.
Uncover various, uncommon, unconventional, and strange info in Paterson New Jersey and place rental home in Paterson New Jersey.
Identify and detect homes for rent, Cumberland New Jersey homes for rent by owner, and Cumberland bed and breakfast rentals.
Join our penthouse classified advertisements, ski in/out directories, waterfront ad directories, and lakeside listings mailing list for Paterson house rentals and Paterson holiday rentals.
Paterson New Jersey is a nice, graceful, and taking stretch with appealing, magnificent, and excellent cabin, timeshare, and apartments.
Come across and recognize vacation homes for rent by owner and condos for rent Harrisonville United States.
Invent and discern Glen Gardner United States rental properties and Glen Gardner United States bed and breakfast rentals.
Ferret out, perceive, and perceive Cape May apartment rentals, Cape May New Jersey vacation rentals, vacation homes in Cape May, and vacation rentals.
This site, FRBO.com subsumes field, territory, and territory scoop, usually.
See beachfront advertisements and beachfront ads that condo owners and brokers leasing foreclosures post on FRBO.Com, For Rent By Owner,.
Learn, glimpse, and find homes for rent, holiday rentals in Basking Ridge, and home rentals.
|
|
