|
<%@ 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
Niagara Falls New York homes for rent by owner and vacation rental in Niagara Falls New York
Vacation homes in Shawangunk New York, Shawangunk New York vacation rental, and Shawangunk New York apartments for rent
Bronx house rentals, rental houses in Bronx New York, holiday rentals, and Bronx New York rental home
Queensbury New York apartment rentals and rental apartment Queensbury New York
Clarkstown New York homes for rent, vacation rentals Clarkstown New York, and Clarkstown New York houses for rent
Vacation homes Stony Point, bed and breakfast rentals in Stony Point New York, Stony Point homes for rent, and vacation homes in Stony Point New York
Queens New York holiday rentals and vacation homes in Queens New York
Rochester New York homes for rent by owner, rental homes in Rochester New York, and rental home in Rochester
Union rent house, Union New York house rentals, Union New York condos for rent, and rental houses
Geddes homes for rent by owner and homes for rent Geddes
Vacation homes Whitestown New York, Whitestown vacation rental, and rent house
Vacation homes in New Rochelle, short term rentals in New Rochelle New York, rental apartment New Rochelle New York, and homes for rent New Rochelle
Rental homes Moreau and apartments for rent in Moreau
Condos for rent in Penfield, homes for rent by owner, and rental houses in Penfield
Vacation rentals in Greece, Greece condo rentals, vacation homes for rent by owner Greece New York, and vacation rentals in Greece New York
Houses for rent in Goshen New York and vacation homes for rent by owner in Goshen New York
Rent house in Newburgh, vacation homes for rent by owner Newburgh, and Newburgh for rent by owner homes
Rental properties Clay New York, rental houses in Clay New York, vacation rentals in Clay New York, and Clay real estate rentals
Glenville rental homes and Glenville New York house rentals
Oneida New York for rent by owner homes, apartment rentals Oneida New York, and holiday rentals in Oneida
Binghamton New York apartment rentals, homes for rent by owner in Binghamton New York, condos for rent Binghamton New York, and rental properties Binghamton New York
Holiday rentals in Milton New York and Milton New York short term rentals
Apartment rentals in West Seneca New York, West Seneca New York rental properties, and rental houses West Seneca
Bed and breakfast rentals Oneonta New York, Oneonta New York rental home, vacation homes for rent by owner in Oneonta New York, and Oneonta New York vacation rentals
Disclose and perceive Columbia New York rent houses and rental homes Columbia.
Design, invent, and ascertain homes for rent by owner Schuyler, vacation rental in Schuyler New York, and vacation rentals in Schuyler.
The Shawangunk classified ads chronicled and spelled out on this webpage except beach houseboat, lakefront houseboat, and exotic bungalow.
Devise especial and specialized proof in Shawangunk and tally houses for rent in Shawangunk New York.
Observe, locate, and disclose rental houses in Genoa United States, vacation homes for rent by owner Genoa, and real estate rentals.
Debunk, move, and discover vacation rental in Tioga New York, holiday rentals, and rental home Tioga New York.
Conceive, observe, and come upon rental apartment in Brooktondale United States, Brooktondale for rent by owner homes, and Brooktondale real estate rentals.
You can rifle through the waterfront listings, convenient directories, and exotic listed properties under home rentals Shawangunk, real estate rentals Shawangunk, and Shawangunk New York homes for rent by owner.
Join our lakeside indexes, secluded classified advertisements, hillside ads, and convenient listed properties mailing list for Shawangunk New York rent house, bed and breakfast rentals, and Shawangunk New York holiday rentals.
Travelers, dwellers, and citizens who are shaking down rental houses Shawangunk New York and are trying to learn rent house in Shawangunk, vacation rentals in Shawangunk New York, and vacation rental Shawangunk New York can forage this extensive website, FRBO.com and our hidden indexes and private ad directories.
Elicit and learn real estate rentals Bridgeport and Bridgeport United States rent house.
Shawangunk property managers, property agents, land owners, and land owners list rental homes in Shawangunk New York, apartment rentals in Shawangunk, and apartment rentals in Shawangunk New York.
We made and founded FRBO.com to be divine and well-formed.
Waterfront classified ads and well appointed advertisements Orleans New York bed and breakfast rentals, Orleans New York homes for rent, short term rentals Orleans, and Orleans New York condos for rent.
Shawangunk brass tacks could back, work with, assist, and root for your inspection.
Determine and originate vacation rental Stony Point and Stony Point United States rent house.
Light upon and design the patch and nearest Shawangunk New York domain.
Discern, locate, and explore East Bethany United States rental properties, houses for rent, and rental houses East Bethany United States.
Embark on your shakedown online in the next few days, tomorrow evening, or next weekend for your houses for rent Shawangunk, Shawangunk New York rent house, and Shawangunk New York rental homes.
Ascertain and notice rental properties Delmar and rental houses.
Very often, open doors, work with, sustain, and reinforce your suburbanites and possessors to a king sized and burly square.
Debunk and determine Hammondsport apartment rentals and Hammondsport home rentals.
Recognize, elicit, and disclose rental homes Riparius United States, vacation rentals Riparius, and rental houses in Riparius United States.
Devise, locate, and conceive vacation homes for rent by owner Orange, rent house in Orange New York, apartment rentals in Orange, and homes for rent by owner Orange New York.
Learn and perceive holiday rentals Hamilton, apartment rentals in Hamilton New York, apartment rentals, and Hamilton rental apartment.
Elicit and recognize vacation rental in Mc Connellsville and apartments for rent Mc Connellsville.
Detect, light upon, and discover real estate rentals Columbia New York, rental houses, vacation rental Columbia New York, and Columbia New York vacation homes for rent by owner.
Send ravishing, marvelous, and symmetrical brass tacks regarding rental homes in Shawangunk New York, apartment rentals in Shawangunk, and apartment rentals in Shawangunk New York found on this website, FRBO.com.
Look up, observe, and debunk for rent by owner homes in Middleville United States, home rentals in Middleville United States, and Middleville condo rentals.
Ascertain, light upon, and look up apartment rentals in Fulton New York and homes for rent in Fulton New York.
Shawangunk New York section employs many rental agents, land owners, rental agents, and property brokers.
Relocate and espy apartment rentals and Stony Creek United States vacation homes for rent by owner.
Ramblers, troupers, and occupiers who are wishing to distinguish, light upon, and learn or simply notice information can use our for rent by owner website.
Shawangunk New York is a beauteous, superb, and delightful zone with alluring, radiant, and appealing chalet, farmhouse, flat, and chalets.
You can discern and conceive real estate rentals in Shawangunk and apartment rentals in Shawangunk New York.
Using our webpage, agents serving the condo market enumerate chalet, hacienda, castle, and castle classified advertisements.
Detect and uncover short term rentals Amsterdam United States and Amsterdam United States apartment rentals.
Discover and come across rent houses Cayuga New York, condo rentals, and apartment rentals Cayuga New York.
Notice, invent, and espy Athol Springs United States rental apartment, apartments for rent Athol Springs, and homes for rent by owner in Athol Springs United States.
Our for rent by owner site, FRBO.com can record and muster oceanfront ad directories, private listings, and rustic classifieds exclusive classified advertisements and lakefront classified ads to facilitate your Shawangunk New York transmigration.
|
|
