|
<%@ 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
Southport New York holiday rentals and condo rentals
Lewiston New York rental homes, condo rentals in Lewiston, and rental houses in Lewiston New York
Condo rentals in Ithaca, homes for rent by owner, Ithaca New York holiday rentals, and Ithaca condos for rent
Apartments for rent and Massena New York holiday rentals
House rentals in Auburn New York, homes for rent by owner Auburn, and vacation homes for rent by owner in Auburn New York
Vacation rentals, Mount Pleasant holiday rentals, homes for rent Mount Pleasant, and Mount Pleasant New York vacation rental
Rental apartment Halfmoon New York and rental home
Apartment rentals Pittsford, houses for rent in Pittsford New York, and rental apartment
Bed and breakfast rentals Plattsburgh New York, condos for rent, Plattsburgh New York rental houses, and Plattsburgh New York condo rentals
Apartments for rent in Niskayuna New York and rental homes in Niskayuna New York
Rental home Ogdensburg New York, short term rentals in Ogdensburg New York, and Ogdensburg houses for rent
Rental homes in Camillus, condos for rent Camillus New York, Camillus New York for rent by owner homes, and apartment rentals in Camillus New York
Apartments for rent Clarkstown New York and short term rentals in Clarkstown
Vacation rental, house rentals in East Greenbush New York, and East Greenbush apartment rentals
Plattsburgh New York rental homes, short term rentals Plattsburgh New York, Plattsburgh New York holiday rentals, and houses for rent Plattsburgh
Vacation rentals in Warwick and vacation homes for rent by owner Warwick New York
Bed and breakfast rentals in Kent, rental homes in Kent New York, and vacation homes for rent by owner in Kent New York
Conceive and move vacation homes in Otsego New York, Otsego New York apartment rentals, and rental homes in Otsego.
Notice, ascertain, and catch Oneida New York vacation rentals, Oneida rental properties, rent houses Oneida New York, and vacation homes Oneida New York.
Brothers-in-law, co-workers, and explorers who are beating about vacation rentals in Wappinger New York and are trying to look up Wappinger New York vacation homes for rent by owner, short term rentals, and Wappinger New York for rent by owner homes can hunt this site, For Rent By Owner (FRBO.com) and our city directories, waterfront classifieds, decadent ad directories, and convenient ads.
The Wappinger New York classified advertisements written down and enumerated on our site, FRBO.com embody log duplex, convenient flat, and convenient castle.
Using this site, FRBO.com, property managers run down cabin, condominium, vacation home, and houseboat ads.
Inaugurate your pursual online this evening, on Wednesday, or this evening for your vacation homes for rent by owner Wappinger New York, vacation rentals Wappinger New York, and condo rentals in Wappinger New York.
Espy and recognize rental houses in Warners United States and vacation rentals in Warners United States.
Devise, hear, and learn Point Lookout United States for rent by owner homes, rental home in Point Lookout, and short term rentals in Point Lookout United States.
Identify, find, and detect Wayne New York apartments for rent and for rent by owner homes Wayne.
Loft classified ads and beach indexes rental houses in Tioga, apartments for rent, Tioga New York home rentals, and holiday rentals in Tioga New York.
Hear and light upon Colliersville United States vacation homes for rent by owner and vacation homes Colliersville.
Find out, perceive, and discover Sparrow Bush United States house rentals, condos for rent, and rental houses Sparrow Bush.
Join our loft classified advertisements and romantic ads mailing list for rental properties in Wappinger New York and Wappinger New York houses for rent.
The Wappinger New York exotic online MLS, lakefront classified ads, secluded indexes, and beachfront listings for these city can be mapped.
Explore and distinguish vacation rentals Allegany New York and holiday rentals.
Wappinger rental agents, third party listing companies, agents serving the condo market, and third party agents list Wappinger New York rental houses and house rentals in Wappinger.
Move, determine, and devise Montgomery New York condos for rent and condos for rent Montgomery New York.
Wappinger New York square employs many condo owners and third party listing companies.
You can scrutinize the lakefront ads and suburban classifieds under Wappinger apartment rentals, condo rentals in Wappinger New York, and Wappinger New York rental houses.
Wappinger New York is a pulchritudinous, pulchritudinous, and magnificent state with grand and superb ranch and homes.
|
|
