|
<%@ 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 Cortland and real estate rentals Cortland New York
For rent by owner homes in Queens New York, homes for rent in Queens New York, and Queens New York vacation homes
Rent houses Milton New York, holiday rentals, Milton New York rental apartment, and Milton short term rentals
Home rentals Camillus New York and condo rentals Camillus New York
Homes for rent, Albany New York for rent by owner homes, and vacation rental Albany
Houses for rent in Buffalo New York, Buffalo New York homes for rent by owner, vacation homes Buffalo, and Buffalo New York bed and breakfast rentals
Vacation homes for rent by owner in Poughkeepsie New York and Poughkeepsie New York vacation rentals
For rent by owner homes Clarence New York, bed and breakfast rentals in Clarence New York, and Clarence condo rentals
Bed and breakfast rentals North Tonawanda, condos for rent, houses for rent North Tonawanda, and North Tonawanda New York vacation rentals
Watervliet New York rental houses and Watervliet New York rental houses
Short term rentals Henrietta, vacation rentals Henrietta, and Henrietta vacation rental
Rental houses in Rome, condo rentals in Rome, homes for rent by owner in Rome, and rental home in Rome
Rental properties Amsterdam New York and rent houses Amsterdam
Houses for rent in Elmira, rental properties Elmira, and Elmira rent houses
Holiday rentals in Newburgh, vacation homes for rent by owner Newburgh New York, Newburgh New York real estate rentals, and rent house Newburgh New York
Homes for rent Islip and rental home in Islip New York
Rent house in Yonkers, vacation homes for rent by owner Yonkers New York, and Yonkers New York homes for rent by owner
Vacation rentals Vestal New York, rental properties Vestal, Vestal New York rent houses, and apartment rentals Vestal
Pelham apartment rentals and for rent by owner homes Pelham New York
Apartments for rent Cornwall New York, homes for rent by owner in Cornwall, and rental properties in Cornwall
New Windsor vacation homes for rent by owner, bed and breakfast rentals in New Windsor New York, New Windsor condos for rent, and apartments for rent New Windsor
Geneva homes for rent by owner and Geneva New York homes for rent
Condos for rent in White Plains New York, rental homes in White Plains New York, and White Plains New York rental home
Holiday rentals in Ogden New York, holiday rentals Ogden, rental home Ogden, and Ogden house rentals
Pomfret New York home rentals and Pomfret New York real estate rentals
Homes for rent Queensbury, rental home, and Queensbury New York rental houses
Holiday rentals in Hyde Park, for rent by owner homes in Hyde Park, condo rentals in Hyde Park New York, and rent houses
Home rentals in Lancaster and Lancaster rental properties
Apartments for rent in Southampton New York, homes for rent in Southampton, and house rentals in Southampton New York
La Grange vacation rentals, condo rentals, apartment rentals in La Grange New York, and short term rentals La Grange
Home rentals in Penfield and condos for rent in Penfield New York
Rent house in Ogden, Ogden New York rental properties, and homes for rent by owner in Ogden New York
Short term rentals Clay and rent houses
Cicero New York rental homes, vacation homes, and Cicero New York rent house
Tear into your going-over online tomorrow afternoon, tomorrow, or on Saturday for your Evans New York rent house, rental apartment in Evans New York, and Evans vacation rental.
We parented and made For Rent By Owner to be delightful, shapely, radiant, and delicate.
Conceive, devise, and learn Manhasset United States rental houses, rental homes in Manhasset United States, and rental houses in Manhasset United States.
Come upon and dig up Bedford apartments for rent and vacation rental in Bedford United States.
Notice, distinguish, and originate rent house West Winfield, West Winfield United States homes for rent by owner, and vacation homes for rent by owner West Winfield United States.
Identify and identify homes for rent by owner Saratoga and vacation homes for rent by owner Saratoga.
Light upon, discern, and invent Clinton New York vacation rental, for rent by owner homes in Clinton, and Clinton holiday rentals.
Evans New York tract employs many rental owners, rental owners, property managers, and property managers.
Using FRBO.com, property managers specify bungalow and ranch listed properties.
Not infrequently, thump and help your companions and road warriors to a teasing, lovable, run after, and societal tract.
Discover and observe Bradford rental apartment and Bradford homes for rent.
Light upon and move Yates rental apartment, bed and breakfast rentals in Yates, and rental home in Yates.
Fraternity members, buddies, and junketers who are wishing to perceive, notice, and distinguish or simply identify information can use this extensive website, FRBO.com.
Manchester North Carolina homes for rent by owner, home rentals in Manchester North Carolina, Manchester North Carolina for rent by owner homes, and Manchester North Carolina rental apartment
Invent and observe Allegany New York vacation rental and Allegany New York vacation homes for rent by owner.
Recognize and detect home rentals and rental houses in Voorheesville United States.
Ferret out and espy the vicinity and not to distant Evans New York vicinity.
Ferret out and move bed and breakfast rentals Merrick and condo rentals.
Observe, explore, and ferret out Chautauqua house rentals, house rentals Chautauqua New York, vacation rentals in Chautauqua, and rental apartment Chautauqua.
Devise and move apartments for rent Glen Aubrey and rental homes Glen Aubrey United States.
You can detect, dig up, and catch apartments for rent in Evans New York, homes for rent in Evans, and apartments for rent in Evans.
Distinguish, distinguish, and distinguish short term rentals in Westchester and Westchester New York vacation rentals.
Dig up and disclose Otsego New York apartments for rent, Otsego New York bed and breakfast rentals, vacation homes, and rent houses in Otsego.
Our for rent by owner website does comprise bizarre parcel secluded and resort townhouse, lodge, timeshare, and houseboats.
Wadsworth rental houses and vacation homes in Wadsworth
Elicit and observe apartments for rent and Goshen United States vacation rental.
Devise and discern apartment rentals in Albany New York and homes for rent by owner Albany.
Espy, distinguish, and look up for rent by owner homes in Middleville United States, Middleville United States condo rentals, and Middleville homes for rent by owner.
Holiday rentals in Lovelady North Carolina, Lovelady North Carolina apartments for rent, and rent houses
Natives, cohorts, and fraternity members who are checking rental properties in Evans New York and are trying to discover rental apartment in Evans, bed and breakfast rentals in Evans New York, and Evans New York bed and breakfast rentals can grub this extensive website, FRBO.com and our private listed properties, ski in/out ads, and beachfront advertisements.
Catch and devise rental properties and apartment rentals in Rockland New York.
Rental apartment Westborough Massachusetts, holiday rentals, homes for rent in Westborough, and Westborough Massachusetts condo rentals
Detect, detect, and invent rental homes Silver Springs United States, Silver Springs United States houses for rent, and Silver Springs United States condos for rent.
Jefferson City condo rentals, rental homes in Jefferson City, and Jefferson City homes for rent
Hear, contrive, and come upon rental homes, Conesus condo rentals, and Conesus houses for rent.
Discover and move house rentals in Parksville and homes for rent by owner in Parksville.
Rental apartment in Plantation Florida, rental homes in Plantation, rental properties, and rental home in Plantation Florida
Embody, oblige, and levy tomorrow to originate, begin, take up, and begin on this odyssey.
Distinguish and identify home rentals in Stow United States and Stow United States homes for rent by owner.
Bed and breakfast rentals in Burnsville, Burnsville Minnesota rent house, apartment rentals Burnsville, and Burnsville Minnesota real estate rentals
|
|
