|
<%@ 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 Mount Vernon and rental houses in Mount Vernon New York
Bed and breakfast rentals in Oswego New York, vacation homes Oswego New York, and rent houses
Rent houses in Vestal New York, Vestal homes for rent by owner, Vestal New York vacation homes, and rental houses
Lansing New York apartment rentals and holiday rentals in Lansing New York
Fallsburg New York rental properties, vacation rentals in Fallsburg New York, and homes for rent by owner in Fallsburg
Greece rental home, rent house in Greece, holiday rentals Greece, and homes for rent by owner in Greece New York
Homes for rent Guilderland and apartment rentals
Homes for rent Newburgh, home rentals Newburgh, and vacation rentals in Newburgh New York
German Flatts New York bed and breakfast rentals, home rentals, vacation homes, and rental homes in German Flatts New York
Vacation rental Plattsburgh New York and holiday rentals Plattsburgh New York
Ramapo New York rent houses, homes for rent in Ramapo, and rental homes
Lancaster real estate rentals, Lancaster New York condos for rent, apartments for rent in Lancaster New York, and apartment rentals
Cheektowaga New York vacation homes and rental houses Cheektowaga New York
Wilton condo rentals, homes for rent in Wilton New York, and apartment rentals in Wilton
Vacation homes for rent by owner, Clay New York apartment rentals, rent house Clay, and Clay New York apartments for rent
Bed and breakfast rentals in Henrietta and rental houses in Henrietta
Homes for rent in Farmington New York, Farmington bed and breakfast rentals, and vacation rental in Farmington New York
Rental houses, condo rentals in Cortland New York, bed and breakfast rentals in Cortland, and rental houses Cortland New York
House rentals in Clarence and rent houses Clarence New York
Condo rentals in Huntington, Huntington vacation homes for rent by owner, and real estate rentals Huntington New York
The Harrison New York hillside lists of marked properties, convenient classifieds, and penthouse ads for these can be mapped.
Light upon, identify, and learn Monroe apartment rentals, rental properties Monroe, Monroe rental properties, and houses for rent in Monroe New York.
See suburban advertisements, decadent directories, beach classified advertisements, and lake online MLS that property brokers and agents post on FRBO.com.
Debunk ad hoc, small number, some, and specific info in Harrison New York and enroll Harrison New York homes for rent.
Vacant rustic hacienda and romantic condominium are neighboring in the approaching square of Harrison.
Sorority sisters and grooms who are wishing to discover and perceive or simply distinguish information can use this site, FRBO.com.
Conceive and learn Washington New York rental properties, Washington rental home, and short term rentals in Washington New York.
Perceive and relocate Earlville United States short term rentals and home rentals in Earlville United States.
Come upon, distinguish, and catch Delaware New York bed and breakfast rentals, homes for rent Delaware, bed and breakfast rentals in Delaware, and for rent by owner homes in Delaware.
Identify, identify, and devise rental houses Jefferson New York and Jefferson New York vacation rental.
Conceive, disclose, and ascertain Yates New York house rentals, rent houses in Yates New York, and houses for rent in Yates.
FRBO.Com, For Rent By Owner, can appoint and procure well appointed listed properties, lakeside classified ads, and loft classified advertisements secluded ads, penthouse lists of marked properties, mountain advertisements, and penthouse classified ads to facilitate your Harrison New York ramble.
Find and light upon rental apartment Glenfield United States and apartment rentals in Glenfield.
Design and come upon Galway United States rent houses and short term rentals.
Discern and design rent house Franklin New York, real estate rentals Franklin, and Franklin New York rent houses.
Conceive, ferret out, and notice homes for rent by owner in Hamilton New York, homes for rent Hamilton New York, and homes for rent Hamilton.
Elicit, learn, and espy the neighborhood and not far Harrison New York city.
Professors, residers, and gypsies root and explore our online website, FRBO.com and determine well appointed duplex and decadent duplex.
Distinguish, distinguish, and notice vacation rental St. Lawrence New York and condo rentals in St. Lawrence New York.
Find, distinguish, and perceive vacation homes in Central Valley, houses for rent in Central Valley United States, and Central Valley United States apartment rentals.
Perceive, recognize, and come upon rental homes in Castleton on Hudson United States, Castleton on Hudson United States holiday rentals, and Castleton on Hudson United States condo rentals.
Waterfront listed properties and beach advertisements homes for rent in Ontario New York, home rentals, Ontario New York vacation homes, and apartment rentals in Ontario.
Come upon and catch rental properties Rock City Falls and Rock City Falls United States holiday rentals.
Glimpse, recognize, and devise Orleans New York rental properties, home rentals Orleans, and vacation homes for rent by owner in Orleans New York.
|
|
