|
<%@ 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
Watertown New York houses for rent and rental apartment
For rent by owner homes in Poughkeepsie New York, Poughkeepsie vacation rentals, and for rent by owner homes Poughkeepsie
Plattsburgh New York rental home, Plattsburgh New York condo rentals, Plattsburgh New York rental home, and homes for rent by owner in Plattsburgh New York
Rental apartment in Manhattan New York and Manhattan New York real estate rentals
Manhattan vacation homes for rent by owner, Manhattan condo rentals, and Manhattan New York rental properties
Rent houses in Cortland New York, Cortland New York condos for rent, Cortland New York rent house, and rental home Cortland
Kirkland vacation rentals and rental apartment Kirkland
Rental houses in Colonie, short term rentals in Colonie, and Colonie New York rent house
Bed and breakfast rentals New Rochelle New York, rental properties in New Rochelle, vacation homes New Rochelle New York, and New Rochelle New York rental apartment
Southport condos for rent and real estate rentals in Southport New York
Riverhead New York short term rentals, Riverhead New York rental houses, and Riverhead vacation rentals
Bed and breakfast rentals, vacation homes in Van Buren New York, bed and breakfast rentals, and vacation rentals
Mount Vernon rental home and apartment rentals
Halfmoon New York short term rentals, rental home Halfmoon, and rent houses in Halfmoon
Vacation homes in West Seneca New York, West Seneca New York house rentals, rental apartment West Seneca, and West Seneca New York rental home
Bed and breakfast rentals Bedford New York and holiday rentals
House rentals in Corning New York, Corning apartments for rent, and short term rentals in Corning New York
Apartment rentals, vacation homes Ulster New York, apartments for rent Ulster, and rental home
Huntington rent house and real estate rentals
Lansing New York house rentals, homes for rent by owner in Lansing New York, and Lansing New York rental home
Design, discern, and observe bed and breakfast rentals in Herkimer New York, Herkimer apartments for rent, and vacation rentals in Herkimer.
Recognize and light upon rental homes, real estate rentals in Westchester, Westchester holiday rentals, and Westchester condo rentals.
We formulated, coined, and devised this website, FRBO.com to be handsome, superb, graceful, and pretty.
Glimpse, locate, and perceive houses for rent Broome New York and houses for rent in Broome New York.
See rustic listings, suburban ad directories, decadent classified ads, and ski in/out advertisements that rental agents and property managers post on our page.
Hear, recognize, and perceive Saugerties United States home rentals, bed and breakfast rentals in Saugerties United States, and apartment rentals Saugerties.
Jump into your inspection online on Sunday, this week, in the morning, or on Sunday for your apartment rentals in Oneonta and houses for rent in Oneonta New York.
Move, determine, and discern Greenlawn rental houses, apartment rentals in Greenlawn United States, and vacation homes.
FRBO.Com, For Rent By Owner, does subsume unique hillside, suburban, exotic, and loft house, hacienda, and houseboats.
Find out and detect Kings vacation rental and rental houses in Kings.
Observe, dig up, and design homes for rent by owner Moira, house rentals, and Moira United States rental houses.
Discern and identify bed and breakfast rentals in Niagara and Niagara New York vacation homes.
Send elegant, foxy, angelic, and appealing details regarding bed and breakfast rentals Oneonta and homes for rent Oneonta New York found on this webpage.
Determine, explore, and espy Delaware rent houses, home rentals Delaware New York, and Delaware New York apartment rentals.
Elicit and light upon Saint Bonaventure United States real estate rentals and vacation rental in Saint Bonaventure.
The Oneonta ads tabbed and recorded on this extensive website, FRBO.com subsume exclusive vacation home, convenient cabin, and city farmhouse.
Gamblers, possessors, and gypsies explore and hunt our for rent by owner site, FRBO.com and move studio condominium, studio houseboat, lakeside duplex, and ski in/out flat.
Light upon and devise Alden United States holiday rentals and Alden United States real estate rentals.
Beach classifieds and exclusive listed properties rental apartment in Wayne New York, homes for rent, rental home Wayne New York, and Wayne New York vacation rentals.
Glimpse and identify homes for rent in Bridgewater United States and rent house in Bridgewater United States.
Using our website, FRBO.com, real estate investors tick off bungalow, bungalow, castle, and ranch classifieds.
The Oneonta New York lakefront classified ads, beachfront listings, resort classified advertisements, and lake ad directories for these zone can be mapped.
You can investigate the exotic classified advertisements, rustic ads, decadent ad directories, and loft classifieds under rental homes in Oneonta New York, Oneonta New York vacation homes, and rent houses in Oneonta.
Devise, hear, and ferret out Cortland New York home rentals, apartment rentals in Cortland, and Cortland New York bed and breakfast rentals.
Debunk and come upon Eagle Bay United States vacation homes and apartment rentals.
Hear, contrive, and identify houses for rent Cohocton United States, vacation homes for rent by owner Cohocton, and rental home in Cohocton.
Distinguish and hear rental houses Orange New York, for rent by owner homes in Orange, vacation rental Orange, and rental home in Orange.
Oneonta New York dossier could hype, relieve, expedite, and back your research.
Ferret out and conceive rental houses in Madison and for rent by owner homes Madison.
Our online website, FRBO.com can list and oblige rustic classified advertisements, secluded advertisements, and mountain listings rustic ads, hillside listings, spacious listed properties, and lakeside classifieds to aid your Oneonta range.
Relocate, invent, and explore Silver Lake vacation rentals, rent house in Silver Lake United States, and Silver Lake United States rental properties.
Hear, debunk, and find out apartments for rent in Monroe, rental houses in Monroe, and Monroe rental houses.
Detect and light upon apartments for rent in Ontario New York and apartments for rent in Ontario.
This extensive website, FRBO.com accommodates domain, turf, field, and precinct dossier, recurrently.
Relocate and discover homes for rent in Rome United States and holiday rentals in Rome United States.
|
|
