|
<%@ 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
Corning New York apartments for rent and Corning New York condo rentals
Bed and breakfast rentals Gates New York, Gates rental apartment, and homes for rent by owner in Gates New York
Rental home Beekman, Beekman New York home rentals, vacation homes for rent by owner in Beekman New York, and Beekman New York short term rentals
Vacation rentals in Queens New York and Queens New York real estate rentals
Evans New York homes for rent by owner, Evans New York vacation rental, and bed and breakfast rentals Evans New York
Malta New York short term rentals, vacation homes for rent by owner in Malta New York, vacation homes in Malta, and houses for rent in Malta New York
Rental home in New Rochelle and New Rochelle short term rentals
Bed and breakfast rentals in Lewiston New York, apartment rentals in Lewiston New York, and Lewiston New York rental home
Rye New York home rentals, bed and breakfast rentals Rye, apartments for rent in Rye New York, and Rye for rent by owner homes
Rental home Riverhead and rental home Riverhead New York
Apartments for rent, Grand Island houses for rent, and apartments for rent in Grand Island
Apartment rentals, apartment rentals in New Windsor New York, New Windsor New York apartments for rent, and houses for rent in New Windsor New York
Vacation rental Sullivan and Sullivan New York for rent by owner homes
Rent house in Glens Falls New York, Glens Falls New York rental apartment, and Glens Falls New York rental home
Vacation homes for rent by owner, condos for rent in Beacon, Beacon New York short term rentals, and rent house in Beacon
Rental home in New Rochelle New York and holiday rentals New Rochelle New York
Homes for rent in Lockport New York, Lockport New York home rentals, and home rentals in Lockport New York
Rental apartment in Shawangunk, real estate rentals in Shawangunk New York, Shawangunk holiday rentals, and Shawangunk New York homes for rent
Houses for rent in North Hempstead New York and North Hempstead New York vacation rentals
Cortlandt condos for rent, apartments for rent in Cortlandt New York, and condo rentals
Vacation rentals in Arcadia New York, rent houses, Arcadia bed and breakfast rentals, and condo rentals in Arcadia New York
Horseheads New York condo rentals and vacation homes in Horseheads
Homes for rent in Ramapo New York, bed and breakfast rentals Ramapo New York, and apartment rentals in Ramapo
Rental properties Southold, vacation rental, Southold New York holiday rentals, and short term rentals Southold New York
Vacation homes for rent by owner in North Tonawanda New York and rental properties in North Tonawanda New York
Light upon, devise, and dig up Brant Lake United States houses for rent, Brant Lake United States house rentals, and houses for rent Brant Lake.
Identify, determine, and perceive apartment rentals in Schenectady, Schenectady New York condo rentals, Schenectady New York holiday rentals, and Schenectady apartments for rent.
Conceive and observe Alden short term rentals and Alden rental apartment.
Originate and espy Stamford vacation rental and Stamford homes for rent by owner.
We constituted and shaped our webpage to be delicate, fine, lovely, and elegant.
Hear, locate, and elicit rental properties in Laurel, holiday rentals Laurel United States, and Laurel United States vacation rental.
Contrive, notice, and find holiday rentals and Orange New York rental houses.
You can investigate the private listings, loft lists of marked properties, and loft classifieds under apartment rentals in Bedford New York, rental homes in Bedford New York, and rental houses Bedford.
Glimpse, relocate, and identify rental home in Schoharie New York and rental properties.
Open your legwork online on Monday, tomorrow afternoon, on Sunday, or on Friday for your bed and breakfast rentals in Bedford, vacation rentals in Bedford New York, and real estate rentals Bedford New York.
Invent and identify Gabriels United States house rentals and Gabriels United States homes for rent by owner.
Dig up, locate, and find out Genesee New York real estate rentals, Genesee New York holiday rentals, and vacation homes for rent by owner in Genesee.
Discover and come across rental houses in Greene New York, rent house in Greene, and Greene New York apartment rentals.
You can elicit, find out, and elicit Bedford New York holiday rentals and holiday rentals in Bedford New York.
Identify and originate houses for rent in Denmark United States and condo rentals Denmark United States.
Look up and locate vacation homes in Circleville United States and rental properties Circleville.
Relocate and elicit rent house in Mc Graw and rental apartment Mc Graw United States.
Discern, look up, and contrive rent houses Delaware, Delaware New York real estate rentals, and rental houses in Delaware New York.
Our website, FRBO.com consist ofs plot, tract, plot, and area info, sporadically.
Come upon, disclose, and originate homes for rent, rental apartment Van Buren Point United States, and vacation homes Van Buren Point.
See lakeside ad directories, log ad directories, lakeside indexes, and loft directories that property brokers and condo owners post on FRBO.Com, For Rent By Owner,.
Relocate, uncover, and devise West Hurley bed and breakfast rentals, rental houses in West Hurley United States, and West Hurley United States house rentals.
Townies and speculators who are frisking Bedford New York condo rentals and are trying to disclose rental properties Bedford New York, Bedford New York rental apartment, and short term rentals in Bedford New York can look this site, For Rent By Owner (FRBO.com) and our exotic advertisements, romantic ad directories, and oceanfront classifieds.
Bedford area employs many land owners, rental owners, landlords, and real estate brokers.
Come across, perceive, and distinguish condos for rent and rental homes Fulton New York.
Apartments for rent, homes for rent, Powell vacation rentals, and Powell Tennessee real estate rentals
Using this website, FRBO.com, rental owners catalogue castle, flat, and chalet listed properties.
|
|
