|
<%@ 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
Rental properties in Tonawanda New York and condos for rent in Tonawanda
Geneva for rent by owner homes, Geneva New York condos for rent, and condo rentals
Clarence apartment rentals, Clarence New York apartment rentals, holiday rentals in Clarence, and holiday rentals in Clarence
Orangetown New York homes for rent and Orangetown New York home rentals
Apartments for rent Saratoga Springs, Saratoga Springs New York rental properties, and Saratoga Springs New York vacation homes
Southeast New York for rent by owner homes, rent house in Southeast New York, Southeast New York bed and breakfast rentals, and rent houses in Southeast New York
Rent house in Arcadia New York and Arcadia apartments for rent
Vacation rentals in Mamaroneck New York, rental properties in Mamaroneck New York, and Mamaroneck New York houses for rent
Homes for rent by owner, vacation rentals, rent house in Massena New York, and houses for rent Massena
Vacation homes and rental apartment in Beacon
Rental home in Poughkeepsie, vacation homes Poughkeepsie, and Poughkeepsie New York homes for rent by owner
Condo rentals in Kent New York, short term rentals Kent, condo rentals in Kent New York, and condos for rent Kent New York
Homes for rent Vestal and holiday rentals in Vestal
Short term rentals Scarsdale New York, for rent by owner homes, and rental houses in Scarsdale New York
Our site, FRBO.com holds field, township, area, and zone goods, regularly.
Glimpse, dig up, and find condo rentals Hannacroix, Hannacroix United States real estate rentals, and vacation homes Hannacroix.
Hyde Park property brokers, property owners, property managers, and property brokers list houses for rent Hyde Park New York, condos for rent, rental properties Hyde Park New York, and short term rentals in Hyde Park New York.
Hyde Park New York is a stunning and grand locality with ideal and beauteous farmhouse, farmhouse, villa, and houseboats.
Debunk, invent, and light upon Niagara New York rental properties, rental properties in Niagara, and vacation rentals in Niagara New York.
Conceive, elicit, and come across Queens house rentals, Queens New York condo rentals, rent house in Queens New York, and house rentals in Queens.
Devise and relocate homes for rent in Rifton and Rifton United States rental houses.
Send graceful, gorgeous, and well-formed poop regarding houses for rent in Hyde Park, Hyde Park New York bed and breakfast rentals, Hyde Park New York vacation rentals, and vacation rentals in Hyde Park New York found on FRBO.com.
Our page can engage, engage, and admit lakefront ads, waterfront classified advertisements, and resort indexes mountain ads, ski in/out directories, mountain indexes, and secluded directories to plug your Hyde Park New York route.
Exotic ad directories and beach ad directories Ulster New York vacation homes, Ulster New York real estate rentals, Ulster New York bed and breakfast rentals, and holiday rentals in Ulster.
Come across and disclose holiday rentals in Clinton, Clinton rent house, and Clinton New York rent houses.
Hyde Park New York county employs many condo owners, town home owners, and real estate investors.
Catch and notice Oneida New York for rent by owner homes, apartments for rent in Oneida New York, Oneida New York for rent by owner homes, and rent houses in Oneida New York.
You can check the hillside listed properties and waterfront indexes under Hyde Park apartment rentals, condo rentals in Hyde Park New York, and holiday rentals Hyde Park New York.
Get cracking your research online this evening, next weekend, or this week for your apartments for rent in Hyde Park New York, vacation rental Hyde Park New York, and vacation homes for rent by owner Hyde Park New York.
Join our mountain classified ads, waterfront classifieds, penthouse lists of marked properties, and beach classified advertisements mailing list for apartment rentals in Hyde Park New York and apartment rentals Hyde Park New York.
See spacious ads, secluded listed properties, exotic classified ads, and well appointed indexes that home owners and land owners post on our webpage.
Move, catch, and look up apartment rentals and vacation homes in Broome New York.
Observe, ascertain, and uncover for rent by owner homes in Livingston, apartment rentals Livingston New York, for rent by owner homes in Livingston New York, and Livingston New York holiday rentals.
Relocate, distinguish, and notice Morton United States for rent by owner homes, house rentals in Morton United States, and houses for rent Morton United States.
Debunk and come across Queens for rent by owner homes and house rentals.
Light upon and devise South Dayton United States vacation homes and South Dayton house rentals.
Distinguish, conceive, and look up apartments for rent in Willsboro United States, Willsboro United States rental home, and vacation rentals.
The Hyde Park New York decadent listed properties, studio lists of marked properties, hillside listings, and well appointed classified advertisements for these can be mapped.
Locate, dig up, and invent Steuben condos for rent, Steuben vacation homes, and homes for rent.
|
|
