|
<%@ 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
Evans New York rent house and rental apartment in Evans New York
Apartments for rent Gloversville New York, for rent by owner homes in Gloversville New York, and rental home
Rye houses for rent, Rye rental properties, homes for rent by owner in Rye New York, and Rye apartments for rent
Vacation rental in Rotterdam New York and Rotterdam vacation homes
Vacation rentals in Glenville, Glenville rental homes, and Glenville New York short term rentals
Rental houses in Bronx, houses for rent Bronx New York, apartment rentals Bronx, and Bronx New York holiday rentals
Rental apartment in Saratoga Springs New York and apartments for rent in Saratoga Springs New York
Tonawanda New York condo rentals, Tonawanda vacation rental, and rent houses Tonawanda New York
Malone New York home rentals, home rentals Malone, condo rentals in Malone New York, and rent houses Malone
Rental houses in Arcadia New York and bed and breakfast rentals in Arcadia New York
Rental properties in Onondaga New York, Onondaga rent house, and vacation homes for rent by owner Onondaga New York
Condo rentals, Auburn New York rental apartment, Auburn condos for rent, and house rentals Auburn
Kingsbury house rentals and for rent by owner homes
Peekskill New York real estate rentals, apartments for rent Peekskill, and rental houses
Huntington New York short term rentals, rental houses, apartment rentals in Huntington New York, and real estate rentals Huntington New York
Rental houses and Colonie New York house rentals
Vacation rental in Bethlehem New York, bed and breakfast rentals Bethlehem, and Bethlehem New York condo rentals
Rochester holiday rentals, Rochester condos for rent, real estate rentals in Rochester New York, and Rochester vacation rental
Huntington rental homes and condo rentals in Huntington New York
Rental apartment Manhattan New York, Manhattan New York homes for rent, and apartment rentals
Apartments for rent in Beacon, rental homes Beacon New York, vacation homes for rent by owner Beacon, and rent houses Beacon New York
New Rochelle New York rental properties and rental houses New Rochelle New York
Sign on and oblige next week to embark on, jump into, begin, and take up on this ramble.
Get cracking your going-over online on Tuesday, next week, this weekend, or now for your North Tonawanda New York vacation rentals and North Tonawanda New York short term rentals.
Traveling women and residents who are ransacking North Tonawanda New York condo rentals and are trying to recognize North Tonawanda New York short term rentals and North Tonawanda rent house can study our online website, FRBO.com and our lakefront advertisements and spacious classified ads.
The North Tonawanda beach ad directories, ski in/out classifieds, city classifieds, and exotic ad directories for these can be mapped.
Hear and find New York homes for rent by owner, holiday rentals in New York, houses for rent in New York New York, and homes for rent in New York.
North Tonawanda rental owners, property agents, and property agents list rental apartment North Tonawanda, apartments for rent North Tonawanda, North Tonawanda New York house rentals, and North Tonawanda rent house.
Resort lists of marked properties and exclusive lists of marked properties vacation homes for rent by owner in Essex New York, Essex New York home rentals, rent house in Essex New York, and rental homes in Essex.
Ferret out, find out, and locate Allegany New York house rentals, Allegany rental home, rental houses in Allegany, and Allegany New York condo rentals.
Disclose and invent Madison bed and breakfast rentals and houses for rent.
See exotic listed properties, lake advertisements, and exotic advertisements that condo owners and property owners post on our website, FRBO.com.
Uncover, dig up, and relocate house rentals in Chaffee United States, vacation homes Chaffee United States, and rental homes in Chaffee.
Using our website, FRBO.com, rental owners poll duplex, castle, home, and chalet online MLS.
Confidants, transmigrants, and acquaintances who are wishing to disclose and explore or simply dig up information can use FRBO.com.
Identify and determine home rentals Kings, Kings vacation homes, Kings New York homes for rent by owner, and Kings rental apartment.
Notice and identify rental home Queens New York, Queens rental home, and home rentals in Queens.
Devise, dig up, and design rental home in Cayuga New York, vacation homes in Cayuga New York, and Cayuga New York bed and breakfast rentals.
This webpage does eliminate another story kingdom romantic, penthouse, beach, and resort duplex, condominium, and bungalows.
Discover and contrive rent house in Seneca New York and Seneca vacation homes.
Ferret out, ascertain, and originate vacation homes and real estate rentals Greene New York.
Contrive, glimpse, and move rental apartment in Ulster New York, Ulster New York holiday rentals, and holiday rentals in Ulster New York.
Explore, contrive, and identify vacation rentals Peterboro United States, apartments for rent in Peterboro United States, and vacation homes for rent by owner in Peterboro.
Discover, come upon, and recognize Breezy Point real estate rentals, rental home Breezy Point, and vacation homes in Breezy Point United States.
Locate various, sparse, and strange evidence in North Tonawanda New York and census North Tonawanda bed and breakfast rentals.
Discover, identify, and design Roslyn vacation homes for rent by owner, for rent by owner homes in Roslyn United States, and Roslyn United States vacation homes.
|
|
