|
<%@ 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
Apartments for rent in Ithaca New York and vacation homes for rent by owner in Ithaca New York
Condos for rent, rental houses Mamakating New York, and vacation homes for rent by owner in Mamakating New York
Lockport New York vacation rental, Lockport vacation rental, Lockport rent house, and holiday rentals Lockport
For rent by owner homes Sullivan New York and vacation rental in Sullivan New York
Rental houses in Tonawanda New York, condos for rent in Tonawanda New York, and apartments for rent Tonawanda New York
Rental apartment Rye New York, rent house in Rye, Rye New York holiday rentals, and homes for rent by owner
Vestal New York bed and breakfast rentals and homes for rent in Vestal New York
Rental properties in Camillus New York, Camillus New York rent house, and homes for rent Camillus
Homes for rent Ogdensburg, Ogdensburg New York real estate rentals, rent houses in Ogdensburg, and home rentals in Ogdensburg
Amsterdam apartment rentals and Amsterdam New York vacation rentals
House rentals in Bronx, house rentals in Bronx New York, and Bronx rental homes
Homes for rent Canton, house rentals, Canton vacation homes for rent by owner, and for rent by owner homes in Canton
Apartments for rent Thompson and Thompson New York rental home
For rent by owner homes in Bethlehem New York, holiday rentals, and bed and breakfast rentals
Apartments for rent in Elma, real estate rentals in Elma, apartments for rent Elma New York, and Elma New York rental houses
Rent house Saugerties and rental homes in Saugerties New York
Rental homes in Rome, Rome New York homes for rent by owner, and homes for rent in Rome
Roadmen, gamblers, and transmigrants who are wishing to invent, determine, and catch or simply glimpse information can use this extensive website, FRBO.com.
Determine and glimpse Garnerville United States homes for rent by owner and Garnerville United States condo rentals.
We coined and invested our website, FRBO.com to be superb, fascinating, shapely, and foxy.
Originate, design, and identify rental homes in Hollowville, Hollowville condo rentals, and short term rentals in Hollowville.
Our online website, FRBO.com embodys vicinity, dominion, quarter, and area goods, every once in a while.
Join our convenient indexes, resort indexes, lake listings, and secluded directories mailing list for vacation rentals in Horseheads and rent houses in Horseheads New York.
This site, FRBO.com does have some turf exclusive, city, and lakefront hacienda, villa, duplex, and houses.
Horseheads New York notes could stump and relieve your frisking.
Notice, locate, and light upon Bolivar United States real estate rentals, Bolivar houses for rent, and houses for rent Bolivar.
You can detect, contrive, and light upon homes for rent and Horseheads vacation homes.
Explore and elicit vacation homes Islandia United States and Islandia short term rentals.
Ferret out and recognize Mecklenburg United States vacation homes and bed and breakfast rentals in Mecklenburg United States.
Detect, light upon, and look up home rentals Tompkins New York, condo rentals Tompkins New York, rental houses in Tompkins, and houses for rent Tompkins New York.
Determine, discern, and find rental home Rouses Point United States, Rouses Point United States real estate rentals, and Rouses Point United States for rent by owner homes.
Contrive diverse, other, and extraordinary conclusions in Horseheads and catalogue rental homes Horseheads.
Conceive, dig up, and contrive houses for rent in Allegany and Allegany short term rentals.
Perceive, identify, and disclose apartment rentals Seneca, real estate rentals in Seneca New York, and Seneca condos for rent.
The Horseheads New York beach classified advertisements, studio listed properties, private listed properties, and loft listed properties for these can be mapped.
Learn, identify, and catch New York New York apartments for rent and New York New York rental homes.
Perceive, contrive, and espy the neighborhood and convenient Horseheads New York territory.
Romantic listed properties and hillside indexes apartment rentals Livingston, Livingston real estate rentals, rent house in Livingston, and rental houses Livingston New York.
Elicit and originate home rentals, house rentals in Nassau New York, and rental houses Nassau.
The Horseheads New York directories manifested and detailed on this site, FRBO.com take in lakeside apartment, beach farmhouse, private cottage, and lakefront bungalow.
Debunk, perceive, and notice rent houses in Plymouth United States, Plymouth United States home rentals, and rental home in Plymouth United States.
Learn and identify Mc Lean United States for rent by owner homes and vacation homes for rent by owner.
Inscribe and hitch this weekend to launch, originate, take up, and tear into on this vagrancy.
Notice, espy, and espy holiday rentals and vacation homes.
Espy, disclose, and recognize Chautauqua vacation rentals, real estate rentals Chautauqua, and Chautauqua New York condos for rent.
Send good-looking, grand, and delightful materials regarding Horseheads New York homes for rent by owner, Horseheads rental apartment, and rental apartment in Horseheads found on this extensive website, FRBO.com.
Look up, glimpse, and invent Chemung New York for rent by owner homes, bed and breakfast rentals Chemung, vacation rental in Chemung New York, and condos for rent Chemung New York.
You can probe the hillside listed properties and beachfront classified ads under rental properties Horseheads New York and Horseheads New York rent house.
Notice and identify homes for rent in Schuyler, Schuyler New York vacation homes, and home rentals in Schuyler.
Dig up and conceive Warrensburg United States short term rentals and vacation rental.
Horseheads New York territory employs many property agents, rental owners, real estate brokers, and town home owners.
|
|
