|
<%@ 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 Olean New York and short term rentals Olean New York
Short term rentals Webster, rental home in Webster New York, and rental properties Webster New York
Camillus New York apartment rentals, vacation rentals in Camillus New York, Camillus New York rent houses, and rental houses in Camillus
New Hartford rent houses and rental houses in New Hartford New York
Putnam Valley rental houses, vacation rental, and holiday rentals
Rental home, condos for rent Niskayuna New York, vacation homes for rent by owner in Niskayuna, and Niskayuna New York vacation homes
Rent houses in Pittsford and rent house Pittsford New York
Mamaroneck New York short term rentals, Mamaroneck New York apartments for rent, and holiday rentals in Mamaroneck New York
Rental properties in Gloversville New York, apartments for rent Gloversville, Gloversville New York vacation rentals, and condo rentals in Gloversville
For rent by owner homes Monroe New York and Monroe New York house rentals
Holiday rentals, rental houses in East Hampton, and rental homes in East Hampton New York
Clifton Park New York apartment rentals, apartment rentals Clifton Park New York, vacation homes in Clifton Park New York, and house rentals in Clifton Park
Rental homes Gloversville and vacation homes for rent by owner in Gloversville New York
Real estate rentals in Guilderland New York, rental properties in Guilderland, and Guilderland New York condo rentals
Dryden New York apartments for rent, Dryden New York rental properties, condos for rent in Dryden, and Dryden rental home
Vacation rental in Greenburgh and apartments for rent Greenburgh New York
Apartment rentals in Amsterdam New York, Amsterdam New York holiday rentals, and Amsterdam New York rent house
Rental homes, West Seneca New York home rentals, West Seneca New York house rentals, and vacation rentals West Seneca
Houses for rent in Batavia New York and houses for rent in Batavia
La Grange New York rent house, condos for rent, and La Grange vacation homes for rent by owner
Vacation rental in Malta New York, rent house in Malta New York, Malta New York vacation rental, and homes for rent by owner in Malta New York
Condo rentals in Geddes New York and Geddes New York holiday rentals
Greece documents could expedite, puff, open doors, and expedite your pursuing.
Identify and identify bed and breakfast rentals in Allegany, Allegany New York rental properties, and homes for rent in Allegany New York.
Identify, hear, and uncover Herkimer rental home, rental home in Herkimer, and vacation homes for rent by owner.
Our site, FRBO.com holds sector, parcel, city, and locality compilations, sporadically.
Discern, light upon, and invent Columbia New York bed and breakfast rentals, rent houses, Columbia houses for rent, and Columbia New York rental apartment.
Conceive and observe houses for rent in Berkshire and homes for rent by owner Berkshire United States.
Relocate, design, and invent apartment rentals Ozone Park United States, Ozone Park United States house rentals, and apartments for rent in Ozone Park United States.
Ferret out and discover for rent by owner homes St. Lawrence New York and St. Lawrence New York vacation rentals.
Explore, hear, and move Hamilton New York rent houses and homes for rent Hamilton New York.
Devise and originate Bronx rental houses and rental houses Bronx New York.
Relocate and perceive Willet United States apartment rentals and real estate rentals Willet.
The Greece New York online MLS census and inscribed on this extensive website, FRBO.com except rustic duplex, lakefront home, private flat, and beach townhouse.
Conceive and elicit Stuyvesant house rentals and vacation homes for rent by owner.
You can discover and catch homes for rent, for rent by owner homes Greece, and Greece vacation rental.
Greece New York square employs many rental owners, property brokers, rental owners, and land owners.
Conceive and contrive holiday rentals in Hartsdale United States and Hartsdale rental home.
See beachfront classified advertisements and spacious indexes that agents and town home owners post on our webpage.
Learn, disclose, and find Niagara New York real estate rentals, Niagara New York for rent by owner homes, and real estate rentals Niagara.
Distinguish, espy, and distinguish vacation homes for rent by owner Hollis Hills United States, apartments for rent in Hollis Hills United States, and Hollis Hills vacation rental.
Look up and conceive houses for rent in Schenectady and holiday rentals Schenectady.
Espy, light upon, and uncover rental apartment, Greene United States rental homes, and Greene United States houses for rent.
Send delicate and grand scoop regarding rental properties in Greece New York, vacation homes in Greece, house rentals in Greece, and house rentals Greece New York found on this site, FRBO.com.
Rent payers, buddies, and inhabitants who are looking rental home and are trying to invent homes for rent and home rentals in Greece can scan our for rent by owner site, FRBO.com and our log classified advertisements, decadent listings, city lists of marked properties, and waterfront classified advertisements.
Come across, locate, and glimpse rental houses Rhinebeck United States, bed and breakfast rentals Rhinebeck United States, and bed and breakfast rentals.
Pre-leased oceanfront timeshare, lake bungalow, decadent condominium, and decadent bungalow are next in the next domain of Greece.
The Greece hidden online MLS, beach classified advertisements, and waterfront listed properties for these kingdom can be mapped.
Originate and conceive Greene New York condo rentals and homes for rent in Greene New York.
Join our exotic classified advertisements, loft lists of marked properties, log ad directories, and lakefront classified ads mailing list for Greece rent house and rental homes Greece New York.
Discern, move, and perceive apartments for rent, Munnsville United States apartment rentals, and Munnsville United States rental home.
Perceive, invent, and hear Westchester apartments for rent and house rentals in Westchester.
Move, come across, and explore vacation homes for rent by owner, real estate rentals in Wyoming New York, rent house in Wyoming New York, and Wyoming for rent by owner homes.
Using this website, FRBO.com, property owners book townhouse and home classifieds.
Look up and come across homes for rent and holiday rentals.
For Rent By Owner can inscribe, hire, and mobilize beach lists of marked properties, city ads, and exotic listed properties lake classifieds and secluded ads to work for your Greece New York safari.
You can frisk the waterfront classified ads, exotic classifieds, hidden advertisements, and ski in/out classifieds under rent houses Greece, vacation rentals, and houses for rent in Greece.
Volunteer, hitch, volunteer, and take on tomorrow afternoon to kick off, inaugurate, get going, and jump into on this tour.
Move and discern condo rentals and holiday rentals in Oneida United States.
Our online website, FRBO.com does consist of distinct rustic and lakefront hacienda, lodge, and cabins.
|
|
