|
<%@ 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
For rent by owner homes in Rochester New York and rental home in Rochester New York
Lockport apartments for rent, houses for rent Lockport, and for rent by owner homes in Lockport New York
Vacation homes in Wilton New York, for rent by owner homes Wilton, Wilton New York vacation rentals, and rental home in Wilton New York
Mount Vernon house rentals and Mount Vernon New York vacation homes for rent by owner
Condos for rent, houses for rent in Kirkland, and home rentals in Kirkland New York
Parma New York rental houses, apartments for rent Parma, houses for rent in Parma, and rental houses in Parma
Bed and breakfast rentals Dunkirk and vacation rentals in Dunkirk New York
North Greenbush rental home, bed and breakfast rentals North Greenbush, and rent houses in North Greenbush
Geneva New York houses for rent, Geneva home rentals, apartment rentals in Geneva, and houses for rent in Geneva
Real estate rentals New Paltz New York and homes for rent by owner in New Paltz New York
Islip New York rental apartment, Islip rental houses, and Islip rental homes
Apartments for rent in Glenville, for rent by owner homes Glenville New York, vacation homes for rent by owner Glenville, and Glenville New York vacation homes for rent by owner
For rent by owner homes in Henrietta and vacation homes for rent by owner in Henrietta New York
Rye New York rental homes, rent houses Rye New York, and rental homes Rye
Houses for rent in Dunkirk New York, rental apartment Dunkirk, real estate rentals Dunkirk, and rent house Dunkirk New York
Manhattan New York real estate rentals and Manhattan New York rental homes
Vacation rentals in Red Hook, rental properties in Red Hook New York, and vacation homes for rent by owner Red Hook New York
Homes for rent in Pittsford New York, for rent by owner homes, vacation homes for rent by owner Pittsford New York, and homes for rent by owner
Ithaca New York rental home and bed and breakfast rentals Ithaca
Dunkirk New York rental houses, homes for rent in Dunkirk New York, and rent houses in Dunkirk New York
Vacation rental in East Greenbush, apartment rentals, condo rentals in East Greenbush, and East Greenbush apartment rentals
Perinton rental properties and house rentals in Perinton New York
Clarkstown vacation homes for rent by owner, vacation homes in Clarkstown New York, and Clarkstown New York rent house
Vacation rental, for rent by owner homes Schodack New York, real estate rentals in Schodack New York, and Schodack rental houses
Webster New York apartments for rent and real estate rentals Webster New York
Apartments for rent Arcadia, vacation homes for rent by owner in Arcadia New York, and rental properties in Arcadia New York
See log listings, hillside classifieds, rustic lists of marked properties, and spacious advertisements that condo owners and home owners post on For Rent By Owner.
Disclose, notice, and identify Gowanda United States rental homes, apartments for rent in Gowanda, and bed and breakfast rentals in Gowanda United States.
The Wawarsing New York classified ads filed and tabulated on For Rent By Owner subsume lakefront chalet and penthouse ranch.
Find and discover apartment rentals Ardsley United States and homes for rent in Ardsley.
Possessors, opportunists, and entrepreneurs who are wishing to dig up and devise or simply elicit information can use our online website, FRBO.com.
Find out, relocate, and disclose condo rentals, condos for rent, and rental apartment Highland United States.
Dig up, perceive, and design apartment rentals, homes for rent in Webster, and vacation rentals Webster United States.
Come upon, recognize, and ascertain house rentals in Burlingham, rental properties in Burlingham, and house rentals in Burlingham.
Our for rent by owner site, FRBO.com can join up, embody, and record resort classified ads, rustic listings, loft lists of marked properties, and lake listed properties well appointed advertisements and resort classified advertisements to expedite your Wawarsing New York roaming.
Disclose and detect for rent by owner homes and home rentals in Schenevus United States.
This site, For Rent By Owner (FRBO.com) does omit strange township convenient and loft flat, cabin, chalet, and houseboats.
Houses for rent in Coolidge, houses for rent Coolidge Arizona, and for rent by owner homes in Coolidge Arizona
Bed and breakfast rentals and for rent by owner homes Richland-Kennewick
Relocate and notice short term rentals Schoharie New York, vacation rental in Schoharie, and apartment rentals in Schoharie New York.
Invent and move for rent by owner homes in Jefferson New York and for rent by owner homes in Jefferson New York.
Contrive and locate apartments for rent Munnsville and Munnsville rental homes.
Waterfront classifieds and studio advertisements Schuyler New York vacation rental, Schuyler New York vacation rentals, Schuyler New York vacation rental, and rental home.
Disclose and observe vacation homes for rent by owner Cragsmoor and rental apartment.
Learn, observe, and discover Richmond New York rent house, vacation rental in Richmond New York, and vacation homes.
Detect and glimpse vacation homes in Yates New York, Yates New York rental home, and Yates New York rent houses.
Wawarsing New York scoop could ballyhoo, assist, aid, and boost your inquest.
Catch, catch, and relocate for rent by owner homes Orange New York and holiday rentals in Orange New York.
Using our website, FRBO.com, home owners tick off vacation home, townhouse, and vacation home ads.
You can elicit, elicit, and relocate Wawarsing New York condos for rent and rental apartment Wawarsing New York.
Conceive and notice vacation homes for rent by owner Kent and apartment rentals in Kent.
Light upon and learn condos for rent Purling United States and for rent by owner homes in Purling United States.
Detect, look up, and learn short term rentals in Oswego, Oswego homes for rent by owner, and holiday rentals Oswego New York.
|
|
