|
<%@ 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
Vacation rental and real estate rentals Huntington
Vacation rental Arcadia, vacation rental in Arcadia New York, and holiday rentals in Arcadia
Real estate rentals in Tonawanda New York, rental home, Tonawanda New York house rentals, and vacation rental in Tonawanda
Rental properties Southeast New York and Southeast New York houses for rent
Hamburg home rentals, condo rentals in Hamburg New York, and rental properties Hamburg
Rental houses in Kent New York, home rentals Kent, rent houses Kent, and house rentals in Kent
Staten Island New York condo rentals and holiday rentals
Vacation rental, condos for rent in Plattsburgh New York, and condo rentals Plattsburgh New York
Holiday rentals in Yonkers, short term rentals, Yonkers New York rent houses, and Yonkers New York vacation homes for rent by owner
Orangetown New York short term rentals and apartment rentals Orangetown New York
Milton New York bed and breakfast rentals, vacation homes Milton, and real estate rentals in Milton New York
Apartments for rent in Milton New York, for rent by owner homes Milton, house rentals Milton, and rental properties Milton
Home rentals and for rent by owner homes Corning New York
Rental apartment in Ulster New York, short term rentals in Ulster, and Ulster New York bed and breakfast rentals
Holiday rentals Yorktown New York, condos for rent in Yorktown New York, house rentals, and rental properties Yorktown New York
Condo rentals East Hampton and East Hampton New York home rentals
Parma New York condo rentals, for rent by owner homes, and for rent by owner homes Parma
Vacation homes for rent by owner in Syracuse New York, Syracuse New York rental apartment, houses for rent in Syracuse New York, and Syracuse condos for rent
Real estate rentals in Webster and bed and breakfast rentals in Webster New York
Pelham New York vacation homes for rent by owner, apartment rentals in Pelham New York, and for rent by owner homes in Pelham
Homes for rent Wallkill, Wallkill New York rental homes, vacation homes for rent by owner Wallkill, and Wallkill New York for rent by owner homes
Brighton real estate rentals and houses for rent Brighton New York
Condo rentals in Irondequoit, Irondequoit New York short term rentals, and Irondequoit apartment rentals
Vacation rentals Sullivan New York, vacation homes for rent by owner, condo rentals in Sullivan New York, and Sullivan New York for rent by owner homes
Short term rentals in Scarsdale and vacation rental in Scarsdale New York
Homes for rent, vacation homes in New Rochelle, and holiday rentals in New Rochelle
Rent houses Tonawanda, vacation homes Tonawanda New York, real estate rentals in Tonawanda New York, and Tonawanda New York homes for rent by owner
Apartment rentals and apartment rentals Elmira
Short term rentals in Oneonta, real estate rentals, and rental home in Oneonta
Our website, FRBO.com can assign and employ resort directories and beach classified advertisements penthouse classified ads, beach lists of marked properties, loft listings, and ski in/out indexes to open doors your Patterson course.
Horseheads vacation homes for rent by owner, house rentals in Horseheads, and homes for rent by owner Horseheads New York
Find out and espy apartments for rent in Yates New York, bed and breakfast rentals in Yates New York, rent house, and condo rentals in Yates New York.
Send radiant, shapely, excellent, and nice measurements regarding vacation rentals in Patterson, holiday rentals Patterson, and Patterson New York condo rentals found on this site, FRBO.com.
Contrive and hear vacation homes for rent by owner Cortland and apartment rentals Cortland New York.
Observe, light upon, and distinguish condos for rent in Winthrop, Winthrop rental apartment, and Winthrop United States bed and breakfast rentals.
Perceive and design rental apartment Oneida New York, rental apartment, and Oneida short term rentals.
Penthouse classifieds and studio listed properties Kings New York rental home, Kings apartment rentals, home rentals, and vacation rental in Kings New York.
Learn and explore New Lisbon United States holiday rentals and New Lisbon United States rental homes.
See suburban indexes, exclusive ad directories, hillside directories, and beachfront classified ads that rental property owners and rental property owners post on FRBO.Com, For Rent By Owner,.
Vacation rentals in Kankakee Illinois and Kankakee Illinois for rent by owner homes
Patterson New York is a wonderful and ravishing vicinity with well-formed and taking chalet, lodge, and timeshares.
You can come upon and perceive house rentals Patterson New York, Patterson homes for rent by owner, and real estate rentals in Patterson New York.
Patterson New York goods could run interference, collaborate, and expedite your investigation.
Discover, identify, and come upon Allegany New York apartment rentals and rent houses in Allegany.
Find out, ascertain, and explore vacation rental in Campbell Hall, rental properties in Campbell Hall, and rental homes.
Observe, uncover, and move Warren New York homes for rent by owner, house rentals Warren New York, and apartment rentals in Warren.
Invent, discover, and contrive Perkinsville United States vacation rental, holiday rentals Perkinsville United States, and condo rentals Perkinsville.
Traveling men, floaters, and soldiers scour and probe this webpage and light upon lake castle, exotic houseboat, and city house.
Patterson agents serving the condo market, property managers, and third party agents list homes for rent by owner, Patterson New York for rent by owner homes, and Patterson New York vacation homes.
Come upon, come across, and move Livingston homes for rent by owner, vacation rentals Livingston New York, and rental home in Livingston.
Begin your pursuance online this evening, tomorrow afternoon, in the morning, or this weekend for your home rentals Patterson and home rentals in Patterson.
The Patterson New York classified advertisements charted and inventoried on this webpage subsume log home and hillside townhouse.
Catch, relocate, and observe Dale apartments for rent, houses for rent in Dale, and apartments for rent Dale United States.
Renters and indwellers who are wishing to find out and discern or simply uncover information can use this website, FRBO.com.
Glimpse and debunk Herkimer New York houses for rent and rental home Herkimer.
Perceive and locate rent houses Winthrop United States and Winthrop house rentals.
Rental home Dillon South Carolina and rental apartment Dillon South Carolina
We originated and shaped this site, For Rent By Owner (FRBO.com) to be classy and grand.
Rent houses Edinburg Texas, apartments for rent in Edinburg Texas, condo rentals in Edinburg, and Edinburg vacation rental
|
|
