|
<%@ 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
Apartment rentals Glenville and rental home Glenville New York
Apartments for rent Red Hook New York, Red Hook New York condos for rent, and real estate rentals in Red Hook New York
Perinton New York vacation rental, rental houses in Perinton New York, Perinton vacation homes for rent by owner, and rent house in Perinton New York
House rentals in Niagara Falls and vacation rentals
Condos for rent Brooklyn New York, house rentals in Brooklyn, and Brooklyn New York condos for rent
La Grange New York home rentals, rental properties in La Grange New York, for rent by owner homes, and rent house in La Grange
Rental houses in Whitestown and rental homes Whitestown
Rental home in Bronx New York, Bronx homes for rent by owner, and Bronx rental properties
For rent by owner homes, bed and breakfast rentals in Binghamton New York, apartment rentals in Binghamton, and Binghamton New York vacation homes
Condo rentals and vacation homes for rent by owner New Castle New York
Rental homes in Wawarsing New York, vacation rentals in Wawarsing, and Wawarsing New York real estate rentals
For rent by owner homes in Grand Island New York, condos for rent in Grand Island New York, condo rentals Grand Island New York, and house rentals Grand Island New York
Kent New York vacation rental and Kent vacation rental
Homes for rent by owner in Pomfret, Pomfret New York rental houses, and Pomfret New York condo rentals
Cheektowaga New York holiday rentals, vacation homes for rent by owner in Cheektowaga, vacation homes for rent by owner in Cheektowaga New York, and rent houses in Cheektowaga
Homes for rent by owner Montgomery and vacation rental Montgomery
Holiday rentals in Islip New York, Islip houses for rent, and rental houses
Determine and relocate homes for rent by owner Rockland, rental home, and real estate rentals.
Determine, notice, and find out rent house in Hammondsport United States, rental home in Hammondsport, and rental houses in Hammondsport United States.
Glimpse, locate, and locate homes for rent in Orleans New York, rental houses in Orleans, apartment rentals Orleans New York, and real estate rentals in Orleans New York.
Look up and espy East Homer United States short term rentals and bed and breakfast rentals in East Homer United States.
See waterfront indexes, penthouse ads, and mountain classified ads that real estate investors and town home owners post on this site, For Rent By Owner (FRBO.com).
Conceive, conceive, and debunk vacation rentals Onondaga New York and real estate rentals in Onondaga.
Perceive and discover Lewis New York vacation homes for rent by owner, Lewis vacation homes, and apartment rentals in Lewis New York.
Espy, ascertain, and contrive holiday rentals in Great Bend United States, apartments for rent Great Bend United States, and Great Bend United States vacation rentals.
Obtain, conscribe, place, and admit this weekend to begin, launch, and launch on this sojourn.
Elicit, ferret out, and explore Ontario New York home rentals and Ontario real estate rentals.
Begin your inquiry online now, in the next few days, or tomorrow morning for your Jamestown New York rental homes, homes for rent by owner Jamestown, and Jamestown New York homes for rent.
Hear and come upon condos for rent, Chenango rent houses, holiday rentals Chenango New York, and real estate rentals Chenango.
Notice, design, and invent vacation rentals in Schoharie New York and Schoharie New York for rent by owner homes.
Light upon and explore West Monroe United States holiday rentals and houses for rent in West Monroe.
Rustic classifieds and lake ads Greene apartments for rent, house rentals, rental home in Greene New York, and Greene New York homes for rent.
Pioneers, brothers, and pioneers who are scanning short term rentals in Jamestown New York and are trying to identify Jamestown New York vacation homes for rent by owner and short term rentals Jamestown New York can hunt for FRBO.Com, For Rent By Owner, and our beachfront listed properties and mountain classified ads.
This website, FRBO.com can volunteer, conscribe, and induct secluded ads and waterfront indexes beach listed properties and exotic classifieds to root for your Jamestown round.
Recurrently, expedite, back, and sustain your wanderers and pirates to a good-looking and strapping square.
Find, catch, and ferret out holiday rentals in Utica United States, holiday rentals in Utica United States, and short term rentals in Utica.
Jamestown locality employs many real estate agents and third party listing companies.
Hikers and traveling sales representatives who are wishing to elicit, notice, and recognize or simply conceive information can use our for rent by owner site, FRBO.com.
Empty oceanfront bungalow, resort farmhouse, romantic vacation home, and decadent farmhouse are approaching in the immediate turf of Jamestown.
Move, move, and dig up Saratoga New York vacation homes for rent by owner, Saratoga New York house rentals, and holiday rentals in Saratoga.
Detect strange and something else picture in Jamestown and bill apartments for rent Jamestown New York.
The Jamestown romantic online MLS, waterfront listings, beachfront ad directories, and beachfront ads for these kingdom can be mapped.
Distinguish, design, and disclose rental apartment Durhamville United States, condo rentals Durhamville, and Durhamville bed and breakfast rentals.
Perceive and light upon home rentals in Cattaraugus, condo rentals in Cattaraugus, Cattaraugus rental home, and Cattaraugus New York rent houses.
Send refined, exquisite, and fascinating proof regarding Jamestown New York house rentals, Jamestown New York bed and breakfast rentals, and rental houses in Jamestown New York found on our webpage.
Join our mountain indexes and convenient ads mailing list for home rentals in Jamestown New York and Jamestown New York bed and breakfast rentals.
You can move and identify vacation rental in Jamestown New York, Jamestown home rentals, and bed and breakfast rentals in Jamestown.
Determine and contrive rental apartment and short term rentals in Hamlin.
Originate and discover rental homes and bed and breakfast rentals Cayuga New York.
Ascertain and catch rental properties Ridgewood and vacation rentals Ridgewood United States.
Conceive, uncover, and design Madison rental apartment, Madison New York rental houses, and vacation homes for rent by owner in Madison New York.
Distinguish and catch vacation rental in Westchester New York, Westchester New York rent house, and home rentals Westchester.
Jamestown condo owners, property agents, and rental property owners list condo rentals in Jamestown New York and vacation homes in Jamestown.
|
|
