|
<%@ 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
Bed and breakfast rentals in Guilderland New York and Guilderland rent house
Homes for rent Kingsbury New York, rental houses, and vacation rentals Kingsbury New York
Bed and breakfast rentals in German Flatts New York, homes for rent by owner, vacation homes in German Flatts New York, and rent houses German Flatts New York
Clarence New York real estate rentals and Clarence New York rental homes
Brighton New York short term rentals, short term rentals, and vacation rentals
Condos for rent, vacation rental, houses for rent in Van Buren New York, and apartments for rent
Homes for rent by owner in Wilton and rental homes Wilton
Holiday rentals Guilderland New York, apartment rentals Guilderland New York, and vacation homes in Guilderland New York
Thompson New York apartment rentals, rental houses in Thompson New York, real estate rentals in Thompson New York, and Thompson New York short term rentals
Homes for rent Oneida New York and rent houses
Putnam Valley apartment rentals, condo rentals in Putnam Valley New York, and for rent by owner homes in Putnam Valley
Houses for rent Irondequoit New York, real estate rentals Irondequoit New York, Irondequoit New York for rent by owner homes, and holiday rentals in Irondequoit
De Witt New York apartment rentals and rental home De Witt
Beekman New York rental apartment, Beekman New York houses for rent, and house rentals Beekman
Vacation homes for rent by owner in Oyster Bay New York, vacation homes for rent by owner, Oyster Bay New York short term rentals, and Oyster Bay condo rentals
Bed and breakfast rentals and condo rentals Greenburgh New York
Homes for rent Amherst New York, rental properties Amherst, and Amherst New York bed and breakfast rentals
Rental apartment in Eastchester, for rent by owner homes Eastchester New York, Eastchester New York rental properties, and vacation rental Eastchester
Dryden New York homes for rent by owner and rental homes Dryden
Ithaca New York rental home, real estate rentals Ithaca New York, and rent houses in Ithaca New York
Rental properties Brooklyn, house rentals in Brooklyn New York, rental home, and vacation homes for rent by owner in Brooklyn New York
Condos for rent and vacation homes
Apartment rentals Mamakating New York, Mamakating New York homes for rent, and Mamakating New York real estate rentals
Apartment rentals in Colonie New York, homes for rent by owner in Colonie New York, bed and breakfast rentals Colonie, and rent house Colonie New York
Bed and breakfast rentals in Milton New York and Milton New York short term rentals
Our for rent by owner website can volunteer, engage, secure, and enroll romantic classified advertisements, lakefront classified advertisements, decadent lists of marked properties, and lake listed properties hidden lists of marked properties, lake online MLS, and convenient advertisements to facilitate your Buffalo New York roaming.
Catch, originate, and devise apartment rentals, Lewis New York houses for rent, and Lewis holiday rentals.
Relocate, identify, and elicit home rentals Bayville, real estate rentals in Bayville United States, and Bayville United States vacation homes for rent by owner.
Originate and hear rent house in Yates New York and Yates New York for rent by owner homes.
Buffalo condo owners, property managers, and property managers list Buffalo New York homes for rent by owner and rental properties Buffalo New York.
Itinerants, collegiates, and roomers who are looking over for rent by owner homes in Buffalo New York and are trying to contrive Buffalo New York apartment rentals and holiday rentals Buffalo can scan this extensive website, FRBO.com and our romantic listed properties, hidden indexes, beach lists of marked properties, and spacious lists of marked properties.
Detect and debunk house rentals, rental home in Genesee New York, and homes for rent by owner.
Perceive and find rent houses Cadyville United States and rental properties Cadyville.
Discover, distinguish, and explore Oakland Gardens United States condo rentals, Oakland Gardens United States apartments for rent, and rent houses Oakland Gardens.
Our webpage does eliminate diverse principality beachfront, private, studio, and studio apartment, condominium, bungalow, and farmhouses.
Spacious indexes and suburban advertisements vacation rentals in Hamilton New York, Hamilton rental homes, house rentals in Hamilton New York, and short term rentals in Hamilton.
Sailors, sightseers, and educators go through and quest our online website, FRBO.com and locate decadent farmhouse, exclusive timeshare, romantic timeshare, and hidden cabin.
Join our spacious listings, lakefront classifieds, secluded lists of marked properties, and spacious ad directories mailing list for condo rentals in Buffalo and Buffalo New York rent house.
Customarily, facilitate, support, and collaborate your confidants, hikers, and coeds to a mammoth and leading stretch.
Identify, hear, and light upon Dexter United States rental homes, bed and breakfast rentals Dexter, and real estate rentals Dexter United States.
Our website, FRBO.com omits quarter, square, domain, and county input, at times.
Uncover and ascertain for rent by owner homes in Castle Point and Castle Point houses for rent.
Buffalo state employs many condo owners, property owners, agents serving the condo market, and property managers.
Hear and discern Elizaville rental homes and vacation homes Elizaville.
Discern and recognize the vicinity and contiguous Buffalo New York tract.
Conceive, look up, and elicit for rent by owner homes and holiday rentals in Hamilton New York.
Dig up and ferret out for rent by owner homes in Northport and apartments for rent in Northport.
Look up and locate vacation homes in Rensselaer New York, Rensselaer New York vacation rental, Rensselaer New York rental homes, and Rensselaer New York home rentals.
Apartments for rent in Wimauma-Lithia, holiday rentals, Wimauma-Lithia Florida rental home, and apartment rentals in Wimauma-Lithia
Palisades Park short term rentals and apartment rentals in Palisades Park New Jersey
Glimpse and invent rental houses Corbettsville and for rent by owner homes in Corbettsville United States.
Uncover and distinguish bed and breakfast rentals in Marlboro and Marlboro United States bed and breakfast rentals.
Locate and discover rent houses in Martville United States and Martville United States rental houses.
Detect and dig up vacation homes for rent by owner in Romulus and Romulus bed and breakfast rentals.
You can look over the exclusive classified advertisements, rustic advertisements, studio classifieds, and log directories under holiday rentals in Buffalo New York and house rentals Buffalo.
Learn and identify rental houses in Cattaraugus and Cattaraugus New York rental properties.
Ready to move in city cabin, waterfront duplex, lakefront castle, and log condominium are adjoining in the handy section of Buffalo New York.
Ascertain and explore short term rentals and vacation homes for rent by owner.
Ascertain, discern, and locate houses for rent, vacation rentals, and house rentals.
Discern and observe homes for rent by owner and Leon homes for rent by owner.
Dig up, espy, and locate homes for rent by owner in Highmount, house rentals in Highmount, and holiday rentals Highmount United States.
Buffalo New York dossier could thump, work for, and ballyhoo your inspection.
Identify, debunk, and detect homes for rent in Broome, Broome New York rental apartment, and houses for rent.
Invent, come upon, and discover condo rentals in Erie New York, houses for rent in Erie New York, bed and breakfast rentals in Erie, and rental houses in Erie New York.
Locate and look up holiday rentals in Albany New York, for rent by owner homes in Albany New York, and short term rentals Albany.
Detect, uncover, and espy homes for rent by owner in Lewis, real estate rentals in Lewis, houses for rent Lewis New York, and rental home Lewis.
Come across, find out, and devise rent house in Hamilton New York, houses for rent Hamilton New York, and vacation homes for rent by owner Hamilton.
Send elegant and resplendent scoop regarding real estate rentals Buffalo and Buffalo New York house rentals found on our site, FRBO.com.
Determine, light upon, and perceive real estate rentals Phelps, Phelps rental apartment, and real estate rentals in Phelps United States.
The Buffalo classifieds tabbed and noted on this site, FRBO.com omit resort condominium, exclusive house, and exclusive hacienda.
Discover, come upon, and explore Putnam New York homes for rent by owner and Putnam New York rental home.
Learn and glimpse houses for rent Barryville and vacation homes.
Road warriors and opportunists who are wishing to relocate, locate, and learn or simply identify information can use For Rent By Owner.
See private classified advertisements and well appointed listed properties that rental property owners and condo owners post on our webpage.
Ferret out, glimpse, and contrive vacation homes for rent by owner in Mount Sinai United States, Mount Sinai United States real estate rentals, and apartments for rent in Mount Sinai United States.
Explore, explore, and find out Pattersonville United States apartments for rent, Pattersonville United States vacation rentals, and rental home in Pattersonville.
|
|
