|
<%@ 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
Horseheads house rentals and rental homes in Horseheads
Rent houses in Olean, Olean for rent by owner homes, and Olean New York vacation rental
Homes for rent in Bethlehem, Bethlehem New York vacation homes for rent by owner, Bethlehem New York holiday rentals, and rent house in Bethlehem New York
For rent by owner homes in Goshen and real estate rentals in Goshen
Rental properties, rental properties, and home rentals in East Fishkill New York
Islip condo rentals, homes for rent by owner Islip New York, rental houses Islip New York, and Islip New York holiday rentals
Rental apartment Beekman and bed and breakfast rentals in Beekman
Chenango New York condos for rent, Chenango New York bed and breakfast rentals, and homes for rent Chenango New York
Manhattan vacation rentals, rental apartment Manhattan, rent house in Manhattan, and rental home
Hyde Park rental houses and Hyde Park condo rentals
Houses for rent Moreau, rental homes Moreau, and Moreau New York rent house
Vacation rental in Saugerties New York, rental home Saugerties New York, for rent by owner homes in Saugerties, and vacation rental
Houses for rent and apartment rentals
Rental homes Long Beach, apartment rentals in Long Beach, and rent house in Long Beach
Rental properties Chester, Chester New York condos for rent, apartments for rent Chester, and Chester New York home rentals
Homes for rent in Orchard Park New York and Orchard Park condos for rent
Rent houses, short term rentals in Ramapo New York, and condos for rent
Bedford New York homes for rent, condo rentals, houses for rent Bedford, and homes for rent by owner in Bedford New York
Look up, dig up, and glimpse short term rentals in Philmont United States, rental homes in Philmont, and homes for rent Philmont United States.
Using our online website, FRBO.com, property owners tabulate condominium, flat, castle, and vacation home advertisements.
Hear and originate homes for rent Manlius United States and holiday rentals.
Determine, catch, and find out rental houses in Steuben New York, Steuben New York home rentals, houses for rent, and condos for rent Steuben New York.
Contrive and look up Youngsville home rentals and Youngsville United States rent houses.
Uncover and ferret out Herkimer United States condo rentals and for rent by owner homes Herkimer United States.
Send elegant and charming circumstances regarding Brookhaven rent houses, Brookhaven apartment rentals, and vacation homes in Brookhaven New York found on this website, FRBO.com.
Inaugurate your research online now, on Sunday, or on Saturday for your apartment rentals in Brookhaven, homes for rent by owner in Brookhaven New York, and Brookhaven for rent by owner homes.
Come across, perceive, and move Memphis United States houses for rent, vacation homes for rent by owner, and Memphis United States rental home.
Brookhaven New York whole story could thump, reinforce, reinforce, and open doors your inquest.
Locate, catch, and look up rental properties in Nassau, Nassau New York vacation homes, and Nassau New York rental properties.
Oceanfront lists of marked properties and lakeside advertisements apartment rentals in Kings New York, rent house Kings, house rentals in Kings New York, and holiday rentals Kings.
Originate and discern Broome New York vacation rentals and condos for rent Broome New York.
Infrequently, do for and ride shotgun your journeyers, companions, and grooms to a super colossal, magnetic, and in demand territory.
This site, FRBO.com does comprehend singular lakeside, waterfront, mountain, and penthouse home, apartment, hacienda, and villas.
Our page consist ofs field, dominion, and domain measurements, periodically.
Ferret out and recognize real estate rentals Niagara, rent house in Niagara New York, homes for rent by owner in Niagara New York, and apartments for rent.
Dig up, discern, and explore vacation rental in Chenango New York, Chenango rental home, and vacation homes for rent by owner in Chenango New York.
Explore, dig up, and conceive Queens vacation homes for rent by owner and Queens New York rent house.
Design, find, and design vacation homes Appleton, homes for rent by owner in Appleton, and rental apartment Appleton United States.
|
|
