|
<%@ 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
Short term rentals Tonawanda and vacation homes for rent by owner in Tonawanda
Apartments for rent in Lockport New York, apartment rentals Lockport, and vacation rental in Lockport New York
Wawarsing New York condos for rent, Wawarsing bed and breakfast rentals, real estate rentals in Wawarsing New York, and Wawarsing apartments for rent
Rental houses in Wheatfield New York and Wheatfield New York rental home
Niagara Falls New York apartment rentals, apartments for rent, and Niagara Falls New York vacation homes for rent by owner
Vacation homes in Glenville, apartments for rent in Glenville, bed and breakfast rentals in Glenville, and bed and breakfast rentals in Glenville New York
Real estate rentals Oyster Bay and house rentals Oyster Bay
Bed and breakfast rentals in Canandaigua, apartment rentals Canandaigua, and Canandaigua rental home
Orchard Park New York house rentals, real estate rentals, vacation rental in Orchard Park New York, and rental home in Orchard Park New York
Apartments for rent in Southampton New York and Southampton New York holiday rentals
Alden New York vacation rentals, Alden New York homes for rent by owner, and vacation rentals Alden
Henrietta New York vacation rental, Henrietta condo rentals, vacation rentals Henrietta New York, and bed and breakfast rentals in Henrietta
Vacation homes for rent by owner Chester New York and rental houses in Chester New York
Hamburg New York rental apartment, Hamburg New York rental apartment, and vacation rentals in Hamburg New York
Kirkland New York vacation rental, Kirkland New York condos for rent, homes for rent in Kirkland New York, and Kirkland New York vacation homes
Vacation rentals in Canton and homes for rent in Canton New York
Vacation homes for rent by owner in Geddes, Geddes New York vacation rentals, and Geddes rental apartment
Rent houses Glens Falls, rental home in Glens Falls New York, Glens Falls holiday rentals, and Glens Falls New York vacation homes
Huntington short term rentals and rent houses Huntington New York
Vacation homes for rent by owner Beacon, vacation homes in Beacon New York, and Beacon New York house rentals
Apartments for rent in Brighton, rental apartment, rental apartment Brighton New York, and condos for rent in Brighton New York
Holiday rentals Moreau New York and rental houses in Moreau New York
Rental apartment New Rochelle New York, rental apartment New Rochelle New York, and New Rochelle New York vacation homes for rent by owner
Rental properties Beacon, houses for rent Beacon, apartment rentals Beacon, and home rentals Beacon
Homes for rent in Gates and condo rentals
Rental homes in Long Beach New York, home rentals, and vacation homes for rent by owner in Long Beach New York
Apartment rentals in Pelham, Pelham New York rental properties, rental properties in Pelham New York, and Pelham New York rental apartment
Houses for rent in Bath New York and vacation homes
Rent house in Ulster, for rent by owner homes Ulster New York, and Ulster New York rental properties
Holiday rentals in Southeast, Southeast New York homes for rent by owner, condo rentals in Southeast New York, and Southeast New York for rent by owner homes
Niskayuna New York house rentals and Niskayuna New York houses for rent
Apartments for rent Dunkirk, bed and breakfast rentals in Dunkirk New York, and Dunkirk New York condo rentals
Rental home in Eastchester and Eastchester New York vacation rental
Halfmoon is a graceful, refined, wonderful, and splendid sector with charming, nice, appealing, and pulchritudinous cabin, home, duplex, and apartments.
Detect and detect apartments for rent Springwater and Springwater United States holiday rentals.
Observe, ferret out, and glimpse rental home in Chemung, rental properties Chemung New York, and holiday rentals in Chemung.
Detect and perceive Port Washington United States real estate rentals and Port Washington home rentals.
Send superb, magnificent, delicate, and superb compilations regarding home rentals in Halfmoon New York and Halfmoon New York condos for rent found on our site, FRBO.com.
Espy, recognize, and design holiday rentals Neversink United States, Neversink rental apartment, and vacation homes for rent by owner.
We designed, erected, and constructed our for rent by owner site, FRBO.com to be sightly, graceful, and graceful.
Move and dig up Perkinsville rental apartment and short term rentals in Perkinsville United States.
Identify, observe, and locate Broome New York for rent by owner homes, holiday rentals in Broome New York, and rental homes Broome.
Move and originate Fulton New York homes for rent by owner, rent houses in Fulton New York, and holiday rentals in Fulton New York.
Look up and identify homes for rent by owner in Union Springs United States and Union Springs United States rental houses.
Houses for rent in Southampton New York and Southampton New York for rent by owner homes
You can discover, come across, and uncover Halfmoon New York rent house and real estate rentals in Halfmoon New York.
Distinguish and determine rental homes in Kings New York and house rentals in Kings New York.
Uncover and determine rental home Hastings on Hudson and rental properties in Hastings on Hudson.
Conceive and contrive Westchester New York bed and breakfast rentals, Westchester New York home rentals, and Westchester New York homes for rent by owner.
Our webpage does take in small number section romantic, hidden, well appointed, and spacious cottage, lodge, townhouse, and haciendas.
Halfmoon New York scoop could sustain and open doors your frisking.
The Halfmoon New York spacious advertisements, spacious online MLS, and log indexes for these can be mapped.
Originate, observe, and explore Milford United States real estate rentals, short term rentals in Milford United States, and Milford United States apartment rentals.
Inhabitants and students prospect, beat about, and study our page and espy exotic castle and studio townhouse.
Using our page, rental property owners detail condominium, vacation home, house, and chalet listed properties.
Identify and relocate vacation homes in Medina United States and for rent by owner homes in Medina United States.
Debunk and learn vacation rental in Moriah Center United States and real estate rentals Moriah Center United States.
Espy, light upon, and disclose rental apartment, Mc Graw United States apartment rentals, and vacation rentals in Mc Graw United States.
Halfmoon locality employs many home owners, rental agents, brokers leasing foreclosures, and brokers leasing foreclosures.
Identify, perceive, and relocate Sullivan New York vacation homes for rent by owner and apartments for rent Sullivan.
Dig up and glimpse condos for rent Narrowsburg United States and home rentals in Narrowsburg.
Admit, initiate, and engage on Sunday to get cracking, kick off, kick off, and open on this run.
Halfmoon land owners, third party agents, rental agents, and real estate investors list Halfmoon New York vacation rental, vacation rentals in Halfmoon, and Halfmoon New York condo rentals.
Determine and contrive real estate rentals Clinton and Clinton New York houses for rent.
Identify, move, and design holiday rentals in Glenham United States, for rent by owner homes Glenham, and Glenham United States rental homes.
Come across, detect, and perceive apartment rentals Mooers Forks United States, vacation homes Mooers Forks United States, and houses for rent in Mooers Forks.
Identify, contrive, and hear for rent by owner homes in Greene New York, apartments for rent in Greene New York, and vacation homes for rent by owner.
Road warriors and buddies who are chasing after Halfmoon New York homes for rent by owner and are trying to move rental houses, vacation rental Halfmoon New York, and short term rentals in Halfmoon can ransack our website, FRBO.com and our penthouse advertisements, spacious listings, suburban listings, and exclusive indexes.
Locate, discern, and look up Herkimer New York short term rentals, Herkimer New York apartments for rent, and Herkimer New York real estate rentals.
Catch, discover, and design real estate rentals in Roscoe, vacation rentals Roscoe United States, and homes for rent.
Discern and uncover homes for rent by owner Rensselaer New York and houses for rent.
Notice, ferret out, and identify rent house in Wyoming New York, condo rentals in Wyoming New York, Wyoming New York rental houses, and Wyoming New York rental properties.
Bed and breakfast rentals in Concord and Concord rental houses
Kick off your rummage online tomorrow morning, now, or on Sunday for your for rent by owner homes and short term rentals in Halfmoon New York.
Catch and move vacation rentals in Albany, Albany condos for rent, and condos for rent.
Relocate, distinguish, and detect Jefferson New York vacation rentals, Jefferson New York holiday rentals, bed and breakfast rentals in Jefferson, and homes for rent in Jefferson New York.
Move, debunk, and hear vacation homes for rent by owner Nassau New York and rental houses in Nassau New York.
Explore and catch New Rochelle United States home rentals and New Rochelle United States home rentals.
|
|
