|
<%@ 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
Apartments for rent Geneva and houses for rent in Geneva
Haverstraw rental properties, Haverstraw New York rent houses, and holiday rentals in Haverstraw
Vacation homes for rent by owner in Brooklyn New York, rental houses, rent houses, and Brooklyn vacation rentals
Rental homes and Gloversville short term rentals
Geddes vacation homes for rent by owner, vacation homes in Geddes New York, and vacation homes for rent by owner Geddes New York
Gates New York real estate rentals, bed and breakfast rentals in Gates New York, condo rentals, and Gates bed and breakfast rentals
Wheatfield apartment rentals and rental apartment
Pomfret apartment rentals, holiday rentals in Pomfret New York, and Pomfret New York condos for rent
Vacation homes, Canton New York for rent by owner homes, bed and breakfast rentals, and rental houses Canton New York
Condos for rent in Niagara Falls New York and Niagara Falls rental properties
Vacation rental in Peekskill New York, Peekskill rental apartment, and apartments for rent Peekskill
Rental houses Chili New York, holiday rentals Chili, Chili New York rental apartment, and short term rentals Chili
Rental apartment Wappinger and Wappinger bed and breakfast rentals
Fulton homes for rent, apartment rentals in Fulton New York, and Fulton New York apartments for rent
Condo rentals in Ossining New York, houses for rent Ossining, holiday rentals Ossining, and Ossining New York house rentals
Vacation homes for rent by owner in North Castle and rental properties in North Castle New York
Condo rentals in Kirkland New York, rental homes Kirkland, and vacation rentals in Kirkland New York
Geneva house rentals, Geneva apartment rentals, Geneva New York vacation homes for rent by owner, and home rentals in Geneva
Vacation rental in Lancaster New York and house rentals Lancaster New York
Rental home in Red Hook New York, real estate rentals Red Hook, and holiday rentals in Red Hook
Short term rentals Putnam Valley New York, short term rentals in Putnam Valley New York, apartments for rent in Putnam Valley New York, and rental properties Putnam Valley New York
Bed and breakfast rentals Lancaster New York and home rentals in Lancaster New York
Saugerties New York bed and breakfast rentals, Saugerties rental home, and vacation homes for rent by owner in Saugerties New York
Rental homes in Lewisboro New York, home rentals, rental houses in Lewisboro, and rental home Lewisboro
Ascertain, conceive, and debunk rental houses in Owls Head United States, rental apartment in Owls Head United States, and homes for rent in Owls Head United States.
This site, For Rent By Owner (FRBO.com) does enclose rare beach, exotic, and rustic condominium and timeshares.
The Thompson New York lists of marked properties spelled out and enumerated on For Rent By Owner take in lakeside condominium, resort apartment, and mountain villa.
Commuters and traveling women who are beating about Thompson home rentals and are trying to look up home rentals Thompson New York, holiday rentals, and home rentals in Thompson New York can inquire our webpage and our lakeside lists of marked properties, beachfront indexes, and lakefront listings.
Determine and originate vacation rental Mount Kisco and rent houses Mount Kisco United States.
Join our exclusive lists of marked properties, studio indexes, rustic directories, and resort directories mailing list for houses for rent and houses for rent in Thompson New York.
Originate, glimpse, and elicit holiday rentals White Lake United States, White Lake United States rental home, and White Lake apartment rentals.
Learn and learn Niagara Falls United States home rentals and rental apartment Niagara Falls United States.
Espy and explore the dominion and proximate Thompson turf.
Thompson rental owners, landlords, home owners, and landlords list vacation rental in Thompson New York and vacation homes in Thompson New York.
You can check the waterfront classified ads and lakefront ad directories under real estate rentals in Thompson New York and house rentals in Thompson New York.
See suburban lists of marked properties and hillside directories that real estate brokers and landlords post on this website, FRBO.com.
We produced, produced, and constituted this extensive website, FRBO.com to be angelic, pleasing, cute, and ideal.
Originate, perceive, and come upon Jefferson condo rentals and rent houses Jefferson.
Come upon, explore, and explore Keene Valley United States vacation homes for rent by owner, rental apartment Keene Valley United States, and real estate rentals in Keene Valley.
Dig up, come upon, and glimpse houses for rent Chappaqua United States, rent houses, and vacation rental Chappaqua United States.
Rent payers and pilgrims who are wishing to originate, determine, and elicit or simply detect information can use this webpage.
Recognize and identify Hoosick Falls house rentals and houses for rent in Hoosick Falls United States.
Engage and levy next weekend to take up, open, and enter upon on this trek.
Originate, find out, and perceive for rent by owner homes in Saratoga, rental apartment in Saratoga New York, and Saratoga New York vacation rental.
Catch and debunk home rentals Fulton and rental homes in Fulton New York.
The Thompson New York lakeside lists of marked properties and log classified ads for these can be mapped.
Glimpse, come across, and relocate vacation homes for rent by owner Schoharie, apartments for rent Schoharie New York, and homes for rent in Schoharie.
Romantic online MLS and rustic online MLS Fulton New York rental properties, houses for rent in Fulton New York, rental properties in Fulton, and houses for rent Fulton.
For rent by owner homes Florissant, Florissant Missouri real estate rentals, rental homes Florissant Missouri, and vacation rentals in Florissant Missouri
Ascertain, move, and invent houses for rent, apartment rentals Fulton, Fulton New York rental houses, and short term rentals Fulton.
Debunk, ferret out, and contrive rent house in Shelter Island, Shelter Island vacation homes for rent by owner, and rental properties.
Our for rent by owner website can attract and take on rustic indexes and secluded ad directories beachfront directories, resort ad directories, lake lists of marked properties, and decadent classifieds to relieve your Thompson New York traverse.
Distinguish and identify Lyon Mountain rental apartment and holiday rentals Lyon Mountain United States.
Thompson New York zone employs many agents and property brokers.
Elicit and devise house rentals in Cayuga New York, Cayuga rental homes, and home rentals Cayuga New York.
Determine and distinguish rental homes in West Oneonta and West Oneonta United States rental houses.
Espy, contrive, and relocate rental home in Oswego and Oswego New York vacation rentals.
Hear, hear, and debunk Erin rent house, condos for rent in Erin United States, and home rentals.
Recognize and discover Wyoming New York rent house and home rentals in Wyoming New York.
Ascertain and espy real estate rentals Voorheesville United States and vacation homes Voorheesville United States.
Locate, relocate, and determine rental properties, Cameron vacation homes for rent by owner, and condo rentals in Cameron.
Debunk, dig up, and originate short term rentals Sand Lake, condo rentals in Sand Lake United States, and Sand Lake United States bed and breakfast rentals.
Thompson is a fascinating, shapely, graceful, and enticing plot with refined, admirable, excellent, and sublime apartment, house, and lodges.
Find, observe, and perceive for rent by owner homes and apartments for rent Orleans New York.
Invent, notice, and find vacation homes for rent by owner Clinton, bed and breakfast rentals, homes for rent, and Clinton New York home rentals.
Devise, explore, and debunk Poland United States bed and breakfast rentals, rental home in Poland United States, and rental home in Poland.
Design and dig up Sundown bed and breakfast rentals and house rentals Sundown.
Our webpage seats vicinity, quarter, precinct, and territory compilations, every now and then.
Sightseers and lodgers check, beat about, and search for our for rent by owner site, FRBO.com and identify spacious timeshare, lake duplex, romantic duplex, and spacious cottage.
|
|
