|
<%@ 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
Homes for rent by owner and Islip holiday rentals
Rent house in Chili, rent houses in Chili, and vacation rental in Chili New York
Condos for rent in Wawarsing New York, home rentals in Wawarsing New York, Wawarsing condos for rent, and rental homes Wawarsing
Bed and breakfast rentals in Cortlandt and vacation homes for rent by owner Cortlandt
Rental apartment Schenectady, real estate rentals Schenectady New York, and rent houses in Schenectady New York
Condos for rent Newburgh New York, rent house in Newburgh New York, house rentals in Newburgh New York, and rental homes Newburgh New York
Vacation rentals Pomfret and Pomfret houses for rent
Grand Island New York vacation rentals, Grand Island New York for rent by owner homes, and Grand Island New York condos for rent
Southeast New York rent house, rental houses, rental properties in Southeast, and Southeast rental home
Rental houses Chili and Chili vacation homes for rent by owner
Apartments for rent, Albany New York vacation rental, and bed and breakfast rentals Albany New York
Holiday rentals Poughkeepsie, houses for rent Poughkeepsie New York, rental home in Poughkeepsie New York, and condo rentals in Poughkeepsie New York
Pelham vacation rentals and holiday rentals
Vacation rentals Lysander, Lysander New York rental homes, and Lysander New York rental properties
Greece vacation rentals, real estate rentals in Greece New York, houses for rent, and Greece vacation rentals
Real estate rentals in Halfmoon and Halfmoon apartments for rent
Cornwall New York bed and breakfast rentals, short term rentals, and Cornwall New York vacation homes for rent by owner
Rental houses in Somers, rental houses Somers, Somers New York rent house, and for rent by owner homes in Somers New York
Rent houses Oneonta and rental homes Oneonta New York
For rent by owner homes in Schodack New York, apartments for rent in Schodack New York, and houses for rent in Schodack New York
Gloversville New York rental apartment, homes for rent by owner Gloversville New York, home rentals Gloversville, and house rentals Gloversville
Home rentals Clarence and vacation homes in Clarence New York
Holiday rentals in Aurora New York, homes for rent by owner in Aurora, and rental homes
Schenectady bed and breakfast rentals, Schenectady New York real estate rentals, Schenectady New York vacation homes for rent by owner, and Schenectady houses for rent
Rental houses and rental houses in Hempstead New York
Glen Cove for rent by owner homes, Glen Cove New York apartment rentals, and rental houses Glen Cove New York
Occasionally, open doors and relieve your occupiers, fellow workers, and rovers to a prepossessing and accepted stretch.
Vacation homes for rent by owner in Loris South Carolina, vacation homes for rent by owner Loris, rent house in Loris South Carolina, and homes for rent in Loris
Ascertain, identify, and perceive Orleans New York homes for rent, vacation rentals Orleans New York, and Orleans vacation homes for rent by owner.
Better halves and pioneers who are wishing to detect and distinguish or simply conceive information can use our online website, FRBO.com.
Catch, uncover, and glimpse short term rentals in Limerick United States, Limerick United States house rentals, and short term rentals in Limerick United States.
Draft, call up, call up, and embody in the morning to enter upon and begin on this travel.
Explore, glimpse, and discover homes for rent in Delaware New York, holiday rentals in Delaware, vacation homes in Delaware New York, and homes for rent by owner Delaware New York.
Catch, come across, and discern condo rentals in Cleveland United States, Cleveland United States rental home, and condos for rent.
Initiate your legwork online tomorrow or this week for your rental properties in New Rochelle and New Rochelle New York apartment rentals.
Catch another and specific brass tacks in New Rochelle and keep count New Rochelle New York vacation homes for rent by owner.
You can locate, detect, and espy rental home and vacation rental in New Rochelle.
Come across, light upon, and uncover Hamilton New York condo rentals, for rent by owner homes in Hamilton, and Hamilton New York condos for rent.
Discern and debunk homes for rent Penn Yan and home rentals Penn Yan United States.
Glimpse and come across Wolcott United States condos for rent and Wolcott United States vacation rentals.
Glimpse and notice houses for rent Saratoga and Saratoga New York rental home.
New Rochelle New York quarter employs many agents, landlords, and brokers leasing foreclosures.
Elicit, find out, and hear Little Genesee United States holiday rentals, Little Genesee United States vacation homes for rent by owner, and Little Genesee United States home rentals.
Locate, glimpse, and observe Clinton rent house and Clinton New York apartment rentals.
Espy, uncover, and recognize rental homes Herkimer New York and Herkimer New York holiday rentals.
Discern and invent vacation homes Delaware New York, Delaware New York rent house, and home rentals in Delaware New York.
Our online website, FRBO.com can serve and register waterfront directories, studio indexes, spacious listings, and lake classified advertisements penthouse ads and ski in/out listed properties to open doors your New Rochelle New York junket.
Ascertain and locate rent house in Portlandville and Portlandville United States home rentals.
Our site, FRBO.com does arrange startling territory waterfront, mountain, beach, and hillside duplex, houseboat, hacienda, and flats.
Contrive and observe Brockport United States condos for rent and rental properties.
Light upon and disclose Norwich United States rental houses and houses for rent Norwich United States.
Conceive, disclose, and notice bed and breakfast rentals, New York New York condo rentals, and New York homes for rent.
Ferret out, come across, and explore homes for rent by owner in Clifton Springs United States, home rentals Clifton Springs, and Clifton Springs United States vacation homes for rent by owner.
Glimpse, light upon, and ferret out Wevertown United States vacation homes, vacation rentals, and Wevertown rent house.
Look up and observe Hamlin United States vacation homes for rent by owner and Hamlin vacation homes for rent by owner.
Contrive and debunk short term rentals Rockland New York and rent houses in Rockland New York.
Distinguish and discern apartments for rent in Sullivan New York, apartment rentals Sullivan New York, Sullivan New York rent houses, and houses for rent in Sullivan New York.
Identify, determine, and disclose Clinton New York condos for rent and real estate rentals Clinton New York.
FRBO.Com, For Rent By Owner, subsumes county, city, section, and turf poop, intermittently.
Perceive and detect Corinth United States house rentals and Corinth for rent by owner homes.
The New Rochelle New York log lists of marked properties, oceanfront classifieds, and loft advertisements for these plot can be mapped.
Using this site, FRBO.com, condo owners write down flat, vacation home, townhouse, and timeshare listings.
Move and learn apartments for rent in Hamilton, rent houses in Hamilton New York, Hamilton New York rental apartment, and home rentals Hamilton New York.
Determine and disclose vacation homes for rent by owner and rent houses in Java Village United States.
Discern and find out vacation homes, apartment rentals, and houses for rent in Westchester New York.
Rent houses in Fairhaven Massachusetts and apartments for rent in Fairhaven Massachusetts
You can forage the beach ads and beach online MLS under holiday rentals in New Rochelle, vacation homes for rent by owner New Rochelle New York, and vacation homes for rent by owner New Rochelle.
See convenient indexes and ski in/out classified advertisements that condo owners and property owners post on For Rent By Owner.
Commuters, coeds, and traveling men who are hunting for rental homes in New Rochelle New York and are trying to debunk for rent by owner homes in New Rochelle and holiday rentals New Rochelle can frisk our webpage and our ski in/out ad directories, convenient advertisements, hillside classified ads, and decadent ads.
Join our hidden classifieds, loft indexes, waterfront listings, and exotic online MLS mailing list for rental properties New Rochelle and condos for rent New Rochelle New York.
Condo rentals in Davenport Iowa, rental properties in Davenport, and rental homes Davenport Iowa
Glimpse, detect, and originate condo rentals in Esperance United States, rental apartment Esperance, and Esperance United States rental homes.
Hillside classified ads and private ad directories homes for rent by owner Lewis, homes for rent in Lewis New York, Lewis New York rental houses, and holiday rentals.
Recognize, come upon, and notice vacation rentals Amenia, holiday rentals in Amenia United States, and rental apartment in Amenia.
New Rochelle New York reports could sustain, benefit, work with, and do for your shakedown.
New Rochelle New York is a pulchritudinous, classy, and statuesque principality with ravishing, exquisite, and stunning timeshare, ranch, and vacation homes.
|
|
