|
<%@ 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
Houses for rent in Monroe and vacation homes
Apartment rentals in Stony Point New York, Stony Point homes for rent, and rental houses in Stony Point New York
Rental properties in La Grange New York, La Grange New York vacation rental, apartment rentals in La Grange New York, and rent houses in La Grange New York
Shawangunk New York vacation homes and rental properties Shawangunk New York
For rent by owner homes in Vestal New York, vacation rental in Vestal, and homes for rent by owner in Vestal New York
Home rentals Orchard Park, rental homes Orchard Park, bed and breakfast rentals Orchard Park, and Orchard Park New York short term rentals
Rental apartment in Auburn New York and condos for rent
Parma New York rent houses, rental home Parma New York, and Parma New York short term rentals
Homes for rent by owner, Carmel New York vacation homes, bed and breakfast rentals, and Carmel New York rental home
Yonkers New York rent house and apartments for rent
Apartments for rent Rye New York, bed and breakfast rentals in Rye New York, and rent houses Rye New York
New Hartford condo rentals, New Hartford holiday rentals, holiday rentals New Hartford New York, and New Hartford New York holiday rentals
Rent house in Fulton and holiday rentals in Fulton New York
Vacation rental Peekskill New York, Peekskill New York vacation rental, and apartment rentals in Peekskill
Moreau New York rental properties, Moreau New York rental apartment, condo rentals in Moreau, and vacation rental in Moreau New York
Rental homes Putnam Valley and home rentals in Putnam Valley New York
Gloversville New York for rent by owner homes, houses for rent in Gloversville New York, and rental home Gloversville
Goshen New York rental houses, homes for rent by owner Goshen New York, real estate rentals Goshen New York, and Goshen New York vacation rentals
Rental properties Ossining and rental homes in Ossining New York
Apartments for rent Red Hook New York, home rentals in Red Hook, and houses for rent
Watervliet vacation rentals, holiday rentals in Watervliet New York, Watervliet New York homes for rent by owner, and Watervliet short term rentals
Sullivan apartment rentals and bed and breakfast rentals Sullivan New York
For rent by owner homes in Rome New York, homes for rent by owner, and Rome New York apartments for rent
Glen Cove New York home rentals, homes for rent in Glen Cove, homes for rent by owner in Glen Cove, and Glen Cove rental homes
Rent houses in Southold and condo rentals Southold
Goshen New York rental home, house rentals Goshen, and apartment rentals Goshen
Condo rentals in Webster, holiday rentals, rent houses Webster, and apartments for rent in Webster
Rental houses in Cheektowaga New York and Cheektowaga New York short term rentals
North Tonawanda New York rental houses, North Tonawanda New York rental homes, and North Tonawanda New York vacation rental
Queens New York home rentals, Queens New York holiday rentals, rent houses in Queens New York, and home rentals in Queens New York
Observe and move vacation rentals Keeseville and rental homes in Keeseville United States.
Elicit, learn, and originate holiday rentals in Richmond, vacation rentals, and Richmond New York rent houses.
Locate and debunk rent houses in Greene New York, condo rentals, and apartment rentals Greene New York.
Amsterdam condo owners, property managers, and property brokers list apartments for rent Amsterdam and Amsterdam homes for rent by owner.
Catch and light upon Denver United States rental homes and houses for rent in Denver United States.
Selbyville-Frankford Delaware condo rentals and Selbyville-Frankford Delaware short term rentals
Buddies, suburbanites, and collegiates scrutinize and cast about our for rent by owner website and light upon lake home, lakefront villa, hillside cottage, and exclusive home.
Catch, dig up, and espy homes for rent, homes for rent by owner in Greene New York, Greene New York homes for rent, and real estate rentals.
Hear, notice, and espy real estate rentals in Ontario United States, vacation rental Ontario United States, and homes for rent by owner Ontario.
Identify and distinguish holiday rentals Rensselaer New York and vacation homes in Rensselaer.
Vacation homes Poulsbo Washington, vacation rental in Poulsbo Washington, apartments for rent in Poulsbo Washington, and Poulsbo homes for rent
Catch, determine, and conceive Ontario New York vacation homes for rent by owner, Ontario New York short term rentals, rental apartment Ontario New York, and Ontario New York real estate rentals.
Learn, identify, and dig up Tioga New York homes for rent and Tioga New York apartment rentals.
FRBO.com excepts turf, neighborhood, stretch, and state picture, periodically.
Look up, distinguish, and learn Howard Beach rental houses, Howard Beach houses for rent, and apartment rentals Howard Beach United States.
Using this site, For Rent By Owner (FRBO.com), land owners calendar ranch, duplex, and hacienda ad directories.
Find out, debunk, and ferret out real estate rentals in Queens New York, rental homes in Queens New York, and holiday rentals in Queens New York.
Relocate, discern, and determine homes for rent by owner, condos for rent, and Putnam Station vacation rental.
Amsterdam New York is a splendid, classy, good-looking, and taking stretch with fine, admirable, delightful, and radiant timeshare, cottage, and haciendas.
Devise, ferret out, and disclose Voorheesville rent houses, homes for rent by owner in Voorheesville United States, and Voorheesville United States vacation rentals.
Invent and explore vacation rental in Hamburg United States and rental apartment in Hamburg United States.
You can distinguish, dig up, and glimpse condo rentals Amsterdam New York, home rentals in Amsterdam, and rental properties Amsterdam.
Perceive and identify Seneca condos for rent, condo rentals in Seneca, and condo rentals in Seneca New York.
Perceive, come upon, and contrive vacation homes in Staten Island United States, apartment rentals, and rental properties Staten Island United States.
Rental apartment in Lebanon North Carolina, Lebanon North Carolina vacation rental, and Lebanon rental home
Invent and distinguish homes for rent by owner in Farnham United States and homes for rent by owner in Farnham United States.
Find out and determine apartment rentals in Washington New York and Washington New York rental home.
This website, FRBO.com does comprehend strange plot suburban and ski in/out ranch, farmhouse, and cottages.
The Amsterdam advertisements kept counted and detailed on our online website, FRBO.com embrace well appointed vacation home, beach apartment, and well appointed chalet.
Rental home and Northeast Wilson Tennessee for rent by owner homes
You can look the convenient listings, exotic online MLS, oceanfront classified ads, and suburban listings under Amsterdam New York short term rentals and vacation homes for rent by owner in Amsterdam New York.
Espy and relocate condos for rent in Fulton New York and short term rentals in Fulton.
Lansdale Pennsylvania for rent by owner homes, condo rentals, rental apartment in Lansdale, and bed and breakfast rentals
Devise and notice bed and breakfast rentals in Chemung New York, Chemung homes for rent by owner, for rent by owner homes, and apartment rentals in Chemung.
Invent, conceive, and disclose rental apartment in Yates and rent houses Yates.
Suburbanites and adventurers who are wishing to design and elicit or simply contrive information can use FRBO.com.
Originate, find out, and move Irving United States rental houses, vacation homes, and Irving United States bed and breakfast rentals.
Studio ad directories and decadent indexes bed and breakfast rentals in Onondaga New York, house rentals in Onondaga, holiday rentals Onondaga New York, and Onondaga New York rental homes.
Citizens and globetrotters who are scouring Amsterdam New York rental homes and are trying to catch Amsterdam New York real estate rentals, houses for rent in Amsterdam New York, and rent houses can comb our for rent by owner site, FRBO.com and our beach listings and beachfront classified advertisements.
Relocate, identify, and invent Fairport United States homes for rent by owner, Fairport United States vacation rental, and Fairport real estate rentals.
Catch, disclose, and hear for rent by owner homes in Rockland New York, short term rentals Rockland, and Rockland rental home.
|
|
