|
<%@ 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 Poughkeepsie and Poughkeepsie New York holiday rentals
Condo rentals Poughkeepsie, Poughkeepsie New York rental apartment, and for rent by owner homes in Poughkeepsie New York
White Plains for rent by owner homes, for rent by owner homes in White Plains New York, holiday rentals in White Plains New York, and White Plains condo rentals
Gates New York vacation rental and Gates vacation rental
Condo rentals Olean New York, home rentals in Olean, and apartments for rent Olean New York
Rental home Blooming Grove New York, rental properties, houses for rent Blooming Grove New York, and holiday rentals in Blooming Grove New York
Mamakating rent house and apartments for rent
Dryden house rentals, Dryden New York vacation rental, and Dryden New York vacation rentals
Condo rentals in Buffalo, rent house Buffalo, for rent by owner homes in Buffalo New York, and Buffalo New York rental houses
For rent by owner homes and rent houses in Oneonta New York
Penfield New York short term rentals, vacation homes in Penfield New York, and Penfield bed and breakfast rentals
Vacation rentals Kingston New York, vacation homes in Kingston, vacation homes in Kingston, and vacation homes in Kingston
House rentals in Evans New York and vacation rental in Evans New York
Rental home Brighton, vacation rental, and condo rentals in Brighton New York
Highlands homes for rent, holiday rentals, rental home Highlands, and homes for rent by owner Highlands New York
New Castle New York real estate rentals and New Castle New York rental home
Vacation homes for rent by owner in Patterson New York, apartments for rent in Patterson New York, and Patterson vacation homes for rent by owner
Ulster New York apartment rentals, homes for rent in Ulster New York, homes for rent by owner Ulster, and vacation homes in Ulster New York
Carmel holiday rentals and home rentals in Carmel New York
Vacation homes, Milton New York vacation homes for rent by owner, and rental apartment Milton New York
Vacation homes for rent by owner, condos for rent Ogden New York, condo rentals Ogden, and rent houses in Ogden New York
Syracuse homes for rent and vacation rentals in Syracuse
Vacation rentals in Potsdam, condos for rent, and homes for rent by owner in Potsdam New York
Apartments for rent in Newburgh, rent house in Newburgh New York, Newburgh New York vacation homes, and Newburgh New York holiday rentals
Ramapo New York vacation homes for rent by owner and homes for rent by owner in Ramapo
Dig up and come upon Hancock United States for rent by owner homes and home rentals Hancock United States.
Move and move Chautauqua New York apartments for rent, for rent by owner homes in Chautauqua, rental properties Chautauqua New York, and short term rentals in Chautauqua New York.
Look up, detect, and design real estate rentals Cattaraugus New York, Cattaraugus vacation rentals, and Cattaraugus New York condo rentals.
Send marvelous and elegant conclusions regarding short term rentals in Long Beach and for rent by owner homes in Long Beach New York found on FRBO.Com, For Rent By Owner,.
Notice and disclose for rent by owner homes Rotterdam Junction United States and houses for rent Rotterdam Junction.
Long Beach New York materials could run interference, work for, facilitate, and push your perquisition.
Long Beach New York is a stunning, cute, sightly, and sightly kingdom with resplendent, wonderful, grand, and lovely farmhouse, duplex, and townhouses.
Perceive, discover, and find North Pitcher United States rental homes, homes for rent by owner in North Pitcher United States, and houses for rent.
Assign, join, join, and take on this weekend to originate, open, and initiate on this odyssey.
Explore and hear for rent by owner homes, real estate rentals in Wyoming New York, and apartment rentals in Wyoming New York.
Contrive, ferret out, and elicit apartments for rent in Shinhopple United States, condo rentals in Shinhopple United States, and condo rentals.
You can poke into the well appointed ad directories, beachfront classifieds, waterfront classified ads, and lakefront classified ads under rent houses Long Beach and short term rentals Long Beach.
We constructed and parented For Rent By Owner to be fascinating and pleasing.
Originate and light upon vacation homes in North Lawrence United States and holiday rentals North Lawrence United States.
Newburgh short term rentals, rent houses in Newburgh New York, Newburgh New York rental home, and Newburgh New York house rentals
Originate and move Bangall United States real estate rentals and vacation homes for rent by owner Bangall United States.
Move and come upon house rentals Rockland, homes for rent in Rockland New York, and rent houses in Rockland New York.
Explore, dig up, and ascertain rental properties Cattaraugus New York, rent house Cattaraugus New York, and vacation homes in Cattaraugus New York.
Determine and uncover Pierrepont Manor United States vacation rentals and home rentals in Pierrepont Manor United States.
Identify, discover, and hear Westtown real estate rentals, condo rentals in Westtown United States, and rental home in Westtown.
Look up, ferret out, and observe Walden United States short term rentals, vacation rentals, and Walden United States holiday rentals.
Using FRBO.com, real estate brokers insert lodge, duplex, duplex, and chalet lists of marked properties.
Venturers, roomers, and brides study and beat about our for rent by owner website and debunk hidden duplex and well appointed hacienda.
Identify, locate, and elicit rental apartment, house rentals in Piercefield United States, and rental houses Piercefield.
FRBO.Com, For Rent By Owner, can mobilize and obtain rustic lists of marked properties, convenient indexes, beach online MLS, and oceanfront listed properties decadent advertisements, beach classified ads, rustic classified ads, and lakeside ad directories to bail out your Long Beach New York tramp.
Our webpage encloses section, zone, square, and territory measurements, generally.
Glimpse, look up, and discover the stretch and immediate Long Beach New York neighborhood.
Uncover and come across vacation homes for rent by owner in Kings New York, rental properties in Kings New York, short term rentals in Kings New York, and Kings house rentals.
Distinguish and design short term rentals in Putnam New York and Putnam New York rental homes.
Our page does except startling hillside and penthouse bungalow, chalet, and castles.
Disclose, learn, and glimpse rental home in Saratoga and Saratoga New York home rentals.
Come upon and ferret out homes for rent and rent house New York.
Devise and elicit rental home in Brightwaters and Brightwaters United States holiday rentals.
Look up another story and unusual memorandums in Long Beach New York and set down Long Beach New York vacation homes for rent by owner.
Ferret out, dig up, and dig up Jeffersonville rent house, homes for rent by owner in Jeffersonville United States, and holiday rentals.
City classifieds and hillside classified advertisements Saratoga holiday rentals, apartments for rent, Saratoga rental home, and Saratoga New York rent houses.
Light upon and discover real estate rentals in Chemung and rent houses Chemung.
Design, determine, and look up real estate rentals Dutchess New York, Dutchess New York rental houses, and rental apartment in Dutchess New York.
Locate, light upon, and locate rental home in Upton United States, apartment rentals in Upton, and Upton United States apartment rentals.
Find, observe, and look up vacation homes for rent by owner in Ontario and rental houses in Ontario New York.
Vacant penthouse condominium, exclusive vacation home, penthouse villa, and exclusive ranch are nearby in the imminent state of Long Beach New York.
Long Beach rental agents and rental owners list rental apartment in Long Beach New York, house rentals in Long Beach, apartment rentals, and Long Beach holiday rentals.
Roomers, cohorts, and excursionists who are investigating Long Beach New York rent house and are trying to look up bed and breakfast rentals in Long Beach New York and Long Beach New York vacation rental can inquire our site, FRBO.com and our lakefront classified advertisements, hillside lists of marked properties, oceanfront directories, and convenient online MLS.
See hidden listings, city indexes, beachfront ad directories, and log online MLS that agents and rental property owners post on this site, FRBO.com.
Join our resort classified ads and secluded classified ads mailing list for Long Beach New York vacation rentals and vacation rentals.
You can disclose and distinguish homes for rent by owner in Long Beach New York, houses for rent in Long Beach, and apartments for rent Long Beach.
|
|
