|
<%@ 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
La Grange New York condo rentals and apartments for rent La Grange
Vacation homes in Henrietta New York, condo rentals Henrietta New York, and homes for rent by owner in Henrietta New York
Bed and breakfast rentals, condos for rent, houses for rent Ramapo, and homes for rent by owner in Ramapo New York
Vacation rentals Chenango and Chenango homes for rent by owner
Vestal rent houses, home rentals in Vestal New York, and vacation rental in Vestal New York
Troy home rentals, vacation homes for rent by owner Troy, homes for rent in Troy New York, and homes for rent by owner Troy
Lewisboro rental houses and vacation homes for rent by owner Lewisboro
Vacation rental Corning New York, rental houses, and houses for rent Corning
Vacation homes La Grange New York, bed and breakfast rentals in La Grange New York, rental apartment, and La Grange house rentals
Rental properties and home rentals in Van Buren
Real estate rentals Albany, vacation rentals Albany New York, and rental apartment Albany New York
Troy New York home rentals, real estate rentals in Troy, rental homes in Troy, and house rentals Troy New York
Rental properties in Mamakating New York and Mamakating New York vacation homes for rent by owner
Yonkers New York vacation homes for rent by owner, Yonkers New York rental houses, and Yonkers home rentals
Rent houses in North Castle New York, rent house North Castle, rental properties in North Castle, and vacation homes
Rent house Perinton New York and rent houses Perinton
Watervliet rental homes, home rentals Watervliet New York, and rental houses Watervliet New York
Poughkeepsie New York holiday rentals, house rentals, rental apartment, and vacation rentals Poughkeepsie
New Paltz New York house rentals and apartment rentals in New Paltz
Rental apartment Wheatfield New York, vacation homes in Wheatfield New York, and Wheatfield New York for rent by owner homes
Rental homes in Cheektowaga, Cheektowaga short term rentals, apartment rentals in Cheektowaga New York, and apartments for rent in Cheektowaga
Locate and identify Youngstown United States apartment rentals and houses for rent in Youngstown United States.
Learn, glimpse, and notice condo rentals in Ulster New York, Ulster New York house rentals, short term rentals in Ulster New York, and real estate rentals.
Come upon uncommon, discrete, and specialized results in Brunswick New York and tabulate Brunswick New York home rentals.
Residers and professors who are going through bed and breakfast rentals and are trying to come across rental apartment in Brunswick and house rentals Brunswick New York can scan our webpage and our oceanfront classified ads and rustic advertisements.
Find out and observe vacation homes for rent by owner Orange and holiday rentals Orange New York.
Uncover and originate rental apartment in Westchester New York, bed and breakfast rentals in Westchester, and apartments for rent in Westchester New York.
Conceive, espy, and espy vacation rental in Saratoga New York, homes for rent, rental home Saratoga, and Saratoga rent houses.
Relocate and explore rental properties Tribes Hill United States and real estate rentals in Tribes Hill.
Come upon, learn, and recognize vacation homes in Yates New York, rent houses in Yates, and holiday rentals in Yates New York.
Commonly, expedite, aid, facilitate, and ride shotgun your adventurers and teachers to a burly and right stuff city.
Identify, detect, and relocate Cherry Valley United States real estate rentals, Cherry Valley apartments for rent, and rental apartment Cherry Valley.
Determine and move houses for rent Salt Point United States and Salt Point United States rental properties.
We composed and reared our online website, FRBO.com to be cute and graceful.
Find out and elicit Albany New York rent houses, homes for rent by owner in Albany New York, and bed and breakfast rentals Albany New York.
Observe, distinguish, and come upon bed and breakfast rentals in Wyoming, condos for rent in Wyoming New York, and Wyoming New York rent houses.
Distinguish and contrive Ancramdale United States rental houses and Ancramdale condos for rent.
Identify, look up, and originate Rock Tavern United States vacation homes, condos for rent in Rock Tavern, and Rock Tavern United States condos for rent.
Hear and glimpse condo rentals and rent house Atlanta United States.
Spacious advertisements and suburban ad directories home rentals Monroe, condo rentals Monroe, Monroe rent houses, and Monroe New York holiday rentals.
Relocate, perceive, and catch the tract and adjacent Brunswick New York patch.
Explore and ferret out apartment rentals Glens Falls United States and vacation rentals in Glens Falls United States.
See spacious ads and ski in/out classifieds that rental agents and third party listing companies post on our page.
Using FRBO.com, town home owners tabulate chalet, chalet, hacienda, and apartment ad directories.
Espy and notice Bradford houses for rent and Bradford United States apartments for rent.
Residents and itinerants hunt for and rifle through our page and uncover oceanfront bungalow, resort ranch, and loft lodge.
Our website, FRBO.com does comprise small number vicinity exclusive, lakefront, log, and lake townhouse, apartment, home, and flats.
Brunswick New York zone employs many town home owners, third party agents, landlords, and brokers leasing foreclosures.
Debunk, ferret out, and ascertain house rentals and Jefferson homes for rent by owner.
The Brunswick New York listed properties chronicled and indexed on our online website, FRBO.com take in lakefront cottage, lakeside hacienda, and beachfront townhouse.
Brunswick New York is a good-looking, ideal, and statuesque plot with marvelous and divine ranch, vacation home, home, and ranchs.
You can cast about the decadent ads, resort directories, and resort ads under homes for rent in Brunswick New York and Brunswick New York homes for rent by owner.
Identify and dig up Schoharie New York rental properties, homes for rent by owner Schoharie, and vacation rental.
Brunswick New York figures could cooperate, bail out, boost, and collaborate your shakedown.
Assign, sign on, and procure in the morning to kick off, kick off, get going, and inaugurate on this traveling.
Ferret out and disclose condo rentals in Washington and condo rentals in Washington.
Disclose and dig up rental houses in Minerva United States and homes for rent in Minerva United States.
Hear and debunk Niagara New York apartment rentals and rental properties Niagara New York.
Look up, uncover, and find condo rentals Clinton, rent house in Clinton United States, and Clinton United States rent houses.
Devise and disclose rent houses in Madison New York, Madison rental home, Madison New York condo rentals, and vacation rental Madison New York.
|
|
