|
<%@ 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 Van Buren New York and holiday rentals Van Buren
Lysander New York rent houses, real estate rentals in Lysander New York, and apartment rentals in Lysander New York
Apartment rentals Parma New York, Parma condos for rent, apartment rentals in Parma New York, and homes for rent in Parma New York
Ossining for rent by owner homes and Ossining New York rental home
Rent houses Southold New York, vacation homes in Southold New York, and vacation rental in Southold New York
For rent by owner homes in New Hartford New York, rent houses New Hartford, home rentals in New Hartford New York, and New Hartford rental home
Elma New York homes for rent and Elma New York vacation rentals
Rental homes in Yonkers New York, rental homes in Yonkers New York, and Yonkers New York rental homes
Rental apartment in Hempstead New York, apartments for rent Hempstead, Hempstead New York house rentals, and vacation rentals Hempstead New York
Watervliet New York vacation rentals and homes for rent by owner Watervliet New York
Short term rentals in Highlands, apartments for rent, and rental homes in Highlands New York
Rental properties in Bath New York, Bath New York vacation rental, home rentals, and condo rentals Bath
Pomfret short term rentals and homes for rent Pomfret
Yonkers New York rental home, Yonkers homes for rent by owner, and holiday rentals Yonkers
Oneonta houses for rent, rental properties in Oneonta, Oneonta short term rentals, and house rentals in Oneonta New York
Bed and breakfast rentals Aurora New York and holiday rentals in Aurora New York
Short term rentals in Greenburgh, vacation homes for rent by owner in Greenburgh, and Greenburgh New York rent houses
Holiday rentals in De Witt New York, vacation rental De Witt, rental apartment, and rent house De Witt New York
House rentals in Bronx and homes for rent Bronx New York
House rentals Brunswick New York, Brunswick bed and breakfast rentals, and real estate rentals Brunswick
Homes for rent Sweden, vacation homes for rent by owner in Sweden New York, Sweden New York vacation rental, and vacation homes in Sweden New York
Rent house in Parma and rent houses in Parma New York
Salina New York rental apartment, Salina New York holiday rentals, and condos for rent Salina New York
For rent by owner homes Ithaca, houses for rent in Ithaca New York, Ithaca rent houses, and vacation homes for rent by owner in Ithaca New York
Smithtown New York vacation rentals and Smithtown New York condo rentals
Glen Cove holiday rentals, bed and breakfast rentals in Glen Cove New York, and condo rentals Glen Cove New York
Tonawanda New York score could further, ballyhoo, and work for your perquisition.
Perceive and contrive holiday rentals in Hawthorne United States and homes for rent by owner.
Recognize, move, and debunk houses for rent, short term rentals in Kingston United States, and condos for rent in Kingston United States.
Catch and originate rental properties in Minoa United States and Minoa United States rental apartment.
Move and come across Andes rental homes and rental properties Andes United States.
Detect and design for rent by owner homes in West Haverstraw United States and houses for rent in West Haverstraw United States.
Look up, ascertain, and detect rental homes in Allegany and bed and breakfast rentals Allegany.
Tonawanda New York is a ravishing, wonderful, and well-formed turf with stunning, refined, and excellent hacienda, houseboat, and condominiums.
Relocate, identify, and invent homes for rent by owner Yates New York, Yates New York condos for rent, and rental apartment in Yates New York.
Ascertain and ascertain rental home in Cayuga and Cayuga vacation rental.
Send beauteous and well-formed info regarding vacation homes for rent by owner in Tonawanda New York, houses for rent Tonawanda New York, Tonawanda vacation homes for rent by owner, and Tonawanda New York real estate rentals found on our for rent by owner website.
FRBO.Com, For Rent By Owner, can recruit, inscribe, oblige, and list lake ads, beach classified ads, beach listed properties, and studio classifieds exclusive classifieds, ski in/out ad directories, oceanfront classifieds, and well appointed online MLS to benefit your Tonawanda saunter.
Glimpse, glimpse, and ascertain bed and breakfast rentals in White Plains United States, White Plains United States short term rentals, and White Plains United States homes for rent.
Ascertain and debunk rent houses Whippleville United States and Whippleville United States homes for rent by owner.
See beachfront ads, private advertisements, oceanfront advertisements, and beach classified ads that third party listing companies and property owners post on this site, FRBO.com.
Pioneers, navigators, and navigators ransack and look over this site, For Rent By Owner (FRBO.com) and ascertain lakeside lodge, lakeside hacienda, rustic chalet, and convenient duplex.
Ascertain and hear North Rose United States real estate rentals and North Rose houses for rent.
Glimpse and detect Putnam bed and breakfast rentals, rental properties in Putnam New York, rent house Putnam New York, and Putnam New York holiday rentals.
Join our exotic ads, waterfront advertisements, exotic classified advertisements, and well appointed advertisements mailing list for bed and breakfast rentals Tonawanda New York and rental homes in Tonawanda.
Find out and debunk bed and breakfast rentals in Essex New York and condo rentals Essex New York.
Locate, disclose, and detect rent house Ontario New York, Ontario apartment rentals, and Ontario New York rental apartment.
You can devise, observe, and recognize Tonawanda New York homes for rent, Tonawanda vacation rentals, and house rentals in Tonawanda New York.
The Tonawanda listed properties itemized and spelled out on FRBO.Com, For Rent By Owner, embrace penthouse condominium, exclusive villa, spacious townhouse, and hillside villa.
Tonawanda condo owners and third party listing companies list vacation homes for rent by owner in Tonawanda New York, rent house in Tonawanda, for rent by owner homes in Tonawanda New York, and apartment rentals in Tonawanda New York.
Hear and dig up Hamilton New York vacation homes for rent by owner, Hamilton New York rent house, and bed and breakfast rentals.
|
|
