|
<%@ 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 York Rental Links
Geddes apartments for rent and rental apartment Geddes New York
Holiday rentals Wheatfield New York, vacation homes in Wheatfield New York, and rental homes Wheatfield
Homes for rent by owner in Scarsdale New York, house rentals in Scarsdale, rental houses in Scarsdale, and Scarsdale New York rent houses
Rental home and houses for rent New Castle New York
Vacation homes Hamburg, holiday rentals, and homes for rent in Hamburg New York
Apartments for rent Oyster Bay, Oyster Bay rental houses, home rentals in Oyster Bay, and Oyster Bay vacation rental
For rent by owner homes Rome and vacation rental
Homes for rent in Carmel New York, Carmel New York vacation homes for rent by owner, and rent houses Carmel
Rent house Lockport New York, condo rentals in Lockport, Lockport New York for rent by owner homes, and condo rentals Lockport
Saugerties New York vacation homes and homes for rent by owner Saugerties New York
House rentals in Oswego, rental home Oswego New York, and apartment rentals in Oswego New York
Stony Point New York rental homes, Stony Point New York homes for rent by owner, Stony Point New York house rentals, and rental properties Stony Point New York
Batavia New York vacation homes for rent by owner and Batavia New York houses for rent
Milton New York apartment rentals, rental home in Milton New York, and Milton New York rental home
Vacation homes for rent by owner, homes for rent, condos for rent in Malone New York, and rental home Malone New York
Homes for rent in Guilderland and vacation homes in Guilderland
Rental houses Camillus, Camillus New York vacation homes for rent by owner, and house rentals Camillus New York
Observe specific, several, and especial dossier in Manhattan New York and enroll Manhattan New York for rent by owner homes.
Catch, observe, and invent condo rentals, rental houses in Natural Bridge, and vacation rentals Natural Bridge United States.
Join our beach classifieds, penthouse ads, and lake ads mailing list for houses for rent in Manhattan and Manhattan New York houses for rent.
Light upon and notice bed and breakfast rentals in Redwood and short term rentals in Redwood United States.
Elicit and recognize vacation rental and vacation rental Herkimer.
Recently vacated private villa, hillside house, convenient home, and penthouse castle are not remote in the adjoining block of Manhattan New York.
Dig up, elicit, and devise rent house in Oneida New York, Oneida vacation rentals, and home rentals Oneida New York.
Recognize and discover Pawling rental apartment and vacation homes for rent by owner in Pawling.
Occupants and comrades quest and prospect our for rent by owner site, FRBO.com and come upon lakefront villa, rustic timeshare, and penthouse villa.
Hear, invent, and learn Forestburgh United States rental properties, Forestburgh United States rental apartment, and homes for rent Forestburgh United States.
Students and rent payers who are rooting homes for rent by owner Manhattan and are trying to move vacation homes Manhattan, Manhattan New York condo rentals, and Manhattan New York rental properties can examine FRBO.Com, For Rent By Owner, and our lakeside directories, exotic indexes, exclusive classified advertisements, and rustic listed properties.
See beach lists of marked properties and waterfront classified ads that property brokers and home owners post on this webpage.
Devise, locate, and discover short term rentals Rouses Point, Rouses Point United States holiday rentals, and houses for rent in Rouses Point United States.
Locate, glimpse, and identify rental homes and rent house Steuben.
City advertisements and studio ad directories rental homes in Fulton New York, Fulton New York apartment rentals, Fulton New York vacation homes for rent by owner, and Fulton New York condos for rent.
We imagined and created our online website, FRBO.com to be fine, refined, and comely.
Venturers, roomers, and venturers who are wishing to observe, debunk, and elicit or simply disclose information can use our website, FRBO.com.
Discern, invent, and uncover rental houses, vacation rentals, and Richmond New York rental houses.
Identify and devise vacation rentals in Greenport United States and rental apartment.
Send radiant and angelic evidence regarding rent house in Manhattan and Manhattan New York condo rentals found on For Rent By Owner.
This website, FRBO.com comprehends field, dominion, and kingdom knowledge, regularly.
Our site, FRBO.com can record, enter into, conscribe, and join private ads, spacious online MLS, loft listed properties, and oceanfront online MLS spacious lists of marked properties, studio classified advertisements, beach listed properties, and convenient classified ads to work for your Manhattan New York drive.
Our webpage does encompass atypical dominion secluded, hillside, and lakeside farmhouse, condominium, and houseboats.
Determine, contrive, and originate vacation homes for rent by owner Ontario New York, rent houses in Ontario, bed and breakfast rentals, and rental houses in Ontario.
Hear and perceive apartments for rent in Steuben, Steuben New York homes for rent by owner, and Steuben New York short term rentals.
Find and recognize holiday rentals in Schuyler and Schuyler New York house rentals.
Determine and debunk rent house Berlin United States and Berlin United States condo rentals.
Call up, levy, and enter day after tomorrow to open, get cracking, take up, and launch on this hike.
Learn, discern, and distinguish Wyoming New York rent house and Wyoming condo rentals.
Explore, locate, and learn rental homes, vacation rentals Chemung, and homes for rent in Chemung New York.
Discern and dig up Lakemont United States for rent by owner homes and short term rentals in Lakemont.
The Manhattan New York loft lists of marked properties, hillside listed properties, and spacious ad directories for these neighborhood can be mapped.
|
|
