|
<%@ 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
Home rentals in Yorktown and homes for rent by owner Yorktown New York
Yonkers vacation homes, vacation rental in Yonkers New York, and Yonkers New York short term rentals
Ogdensburg short term rentals, rent houses Ogdensburg, rental home in Ogdensburg New York, and Ogdensburg real estate rentals
Oswego New York rent house and Oswego houses for rent
Apartment rentals Albany New York, Albany New York houses for rent, and houses for rent Albany
Rental apartment Ithaca New York, Ithaca New York vacation rentals, vacation homes, and Ithaca houses for rent
Chili New York rental properties and Chili New York vacation homes for rent by owner
Milton rental home, Milton rental home, and vacation rentals
Rent houses Colonie New York, rental apartment in Colonie, rental apartment in Colonie, and condo rentals Colonie New York
Rome New York condo rentals and holiday rentals Rome
Troy New York vacation rentals, house rentals in Troy, and Troy rental homes
Rental houses Newburgh New York, Newburgh rent houses, rental homes in Newburgh, and rent houses Newburgh
Rental houses in Somers and rental homes in Somers
Sullivan New York condos for rent, Sullivan rent house, and rental homes Sullivan New York
Distinguish and contrive rental houses in Chazy United States and Chazy United States for rent by owner homes.
Locate, debunk, and ascertain bed and breakfast rentals in Orleans New York, condo rentals in Orleans New York, holiday rentals, and Orleans New York for rent by owner homes.
Register and place tonight to enter upon, get going, and begin on this exploration.
Elicit, find, and distinguish Leicester United States home rentals, Leicester United States vacation homes, and Leicester United States vacation rental.
See beachfront indexes, well appointed online MLS, and decadent advertisements that rental owners and rental agents post on this webpage.
Join our rustic directories and romantic directories mailing list for vacation rental Staten Island New York and short term rentals in Staten Island.
Convenient classified ads and lake listings bed and breakfast rentals in Yates, vacation homes, rental home in Yates New York, and Yates New York condo rentals.
Design and learn homes for rent and Clinton New York homes for rent.
Locate and light upon homes for rent in Harpersfield and apartment rentals in Harpersfield United States.
The Staten Island New York classified advertisements inscribed and specified on our page consist of hillside castle, studio lodge, beach house, and ski in/out cabin.
Explore, glimpse, and come across rental homes in Schuyler and vacation homes Schuyler New York.
Relocate atypical, various, and special compilations in Staten Island New York and bill rental apartment in Staten Island New York.
Send magnificent and resplendent abstracts regarding Staten Island New York rental home, Staten Island New York houses for rent, and Staten Island New York homes for rent found on our for rent by owner site, FRBO.com.
Find, contrive, and contrive rental home, rent houses, and Lorraine rental houses.
Glimpse and explore apartments for rent in Cropseyville United States and homes for rent by owner.
Find out, identify, and come across rental home Petersburg, Petersburg United States for rent by owner homes, and holiday rentals in Petersburg United States.
Design and look up holiday rentals Otsego, bed and breakfast rentals Otsego New York, and rental properties in Otsego.
Free beach flat and lakeside cottage are not to distant in the nearest turf of Staten Island New York.
Staten Island goods could relieve, ride shotgun, bail out, and facilitate your pursuing.
Staten Island dominion employs many home owners, real estate agents, property owners, and rental agents.
Now and again, benefit, open doors, and abet your residers and trippers to a brimming and in favor county.
Elicit and perceive Ulster New York vacation homes for rent by owner, house rentals in Ulster New York, and real estate rentals in Ulster New York.
Staten Island agents serving the condo market, town home owners, real estate brokers, and land owners list condo rentals Staten Island New York, rental home Staten Island New York, and condo rentals in Staten Island New York.
Catch, recognize, and discern bed and breakfast rentals in United States United States, rental homes in United States United States, and United States United States homes for rent.
Our for rent by owner website take ins plot, city, domain, and precinct memorandums, occasionally.
This extensive website, FRBO.com does comprise unusual zone beach, beach, exclusive, and lakeside townhouse, lodge, home, and homes.
Distinguish and dig up rental apartment in Buskirk United States and Buskirk United States rental apartment.
Recognize, hear, and come upon rental homes Tompkins, Tompkins New York real estate rentals, and houses for rent in Tompkins New York.
Uncover, ascertain, and discover New Kingston short term rentals, New Kingston short term rentals, and New Kingston United States condos for rent.
Ferret out and light upon houses for rent in Port Crane and bed and breakfast rentals in Port Crane.
Schoolmates, excursionists, and pirates scrutinize and seek this site, For Rent By Owner (FRBO.com) and notice secluded condominium, beachfront cabin, oceanfront apartment, and beachfront apartment.
|
|
