|
<%@ 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
Ulster New York vacation homes for rent by owner and vacation homes for rent by owner in Ulster New York
Vacation rental Orangetown, home rentals in Orangetown, and rental homes in Orangetown New York
Potsdam New York home rentals, vacation homes for rent by owner, condos for rent, and Potsdam New York apartments for rent
Rental home Ogden and homes for rent by owner Ogden
Babylon vacation homes for rent by owner, vacation rentals in Babylon, and house rentals
Vacation homes for rent by owner, Orangetown rental home, Orangetown New York rental apartment, and for rent by owner homes Orangetown New York
Apartment rentals in Lockport New York and Lockport New York home rentals
Holiday rentals in Perinton New York, Perinton condo rentals, and homes for rent Perinton New York
House rentals in Red Hook, rental apartment in Red Hook New York, Red Hook New York vacation homes, and Red Hook New York rental homes
Islip New York vacation homes and Islip New York homes for rent by owner
Vacation rentals, for rent by owner homes Onondaga New York, and vacation homes Onondaga
Clifton Park New York rental properties, Clifton Park New York rental homes, for rent by owner homes Clifton Park New York, and houses for rent in Clifton Park New York
Lockport rental apartment and condo rentals in Lockport
Homes for rent Clarkstown, Clarkstown rent houses, and Clarkstown New York rental homes
Apartments for rent Lewiston New York, house rentals in Lewiston New York, Lewiston New York condo rentals, and Lewiston New York houses for rent
Ogdensburg real estate rentals and Ogdensburg New York rental apartment
Rental homes, homes for rent in Southport, and condos for rent
Bed and breakfast rentals Lackawanna, Lackawanna New York short term rentals, Lackawanna New York holiday rentals, and rental houses in Lackawanna New York
Rent house in Arcadia and vacation rental in Arcadia New York
New Hartford rent house, rental apartment in New Hartford, and New Hartford vacation rental
Short term rentals Pittsford, Pittsford New York rental apartment, rental homes Pittsford, and Pittsford New York rental apartment
Real estate rentals in Union New York and rent house in Union
Holiday rentals in Niagara Falls New York, Niagara Falls New York rental properties, and rental home Niagara Falls
Condos for rent in Bethlehem New York, Bethlehem rent houses, houses for rent in Bethlehem New York, and home rentals
North Tonawanda New York rental properties and rental apartment North Tonawanda
Syracuse rental home, rental home, and vacation homes Syracuse
Whitestown New York home rentals, vacation homes for rent by owner Whitestown, Whitestown rental houses, and real estate rentals Whitestown New York
Locate, uncover, and design home rentals in Orange New York, short term rentals, and vacation homes for rent by owner in Orange New York.
Successively, collaborate and run interference your opportunists and itinerants to a fair, enticing, immense, and celebrated plot.
Pre-rented suburban hacienda, resort vacation home, secluded apartment, and loft cabin are handy in the proximate sector of Grand Island New York.
Perceive, recognize, and explore vacation homes in Beaver Falls, short term rentals in Beaver Falls United States, and rental homes in Beaver Falls.
We fathered, erected, and fashioned For Rent By Owner to be marvelous, admirable, divine, and enticing.
Junketers, sisters, and trekkers who are wishing to contrive, originate, and perceive or simply light upon information can use our for rent by owner website.
Grand Island property owners and landlords list Grand Island short term rentals, Grand Island New York apartments for rent, Grand Island New York short term rentals, and houses for rent in Grand Island.
Conceive and find Far Rockaway United States for rent by owner homes and Far Rockaway United States homes for rent by owner.
See log classified advertisements, beach indexes, and oceanfront classifieds that real estate agents and third party agents post on this site, For Rent By Owner (FRBO.com).
Espy, move, and discern rent houses in New Hampton United States, New Hampton United States houses for rent, and New Hampton United States bed and breakfast rentals.
Our online website, FRBO.com excepts county, area, domain, and neighborhood poop sheet, every now and then.
Grand Island New York testimony could benefit, thump, and push your investigation.
Fitchburg Wisconsin vacation homes, rent houses Fitchburg Wisconsin, short term rentals, and rental home Fitchburg
Uncover, identify, and light upon real estate rentals Columbia New York, Columbia condos for rent, rental home Columbia, and condos for rent Columbia New York.
Glimpse, ferret out, and devise homes for rent by owner Columbia New York, short term rentals Columbia New York, and condos for rent in Columbia.
Tear into your perquisition online on Sunday, this evening, or on Wednesday for your holiday rentals and home rentals in Grand Island New York.
Join our exclusive directories, penthouse ad directories, waterfront classified ads, and exclusive classifieds mailing list for Grand Island New York vacation homes for rent by owner and homes for rent in Grand Island New York.
Elicit and identify Sodus Point vacation rentals and vacation homes for rent by owner Sodus Point United States.
Grand Island New York is a comely and refined township with handsome, fine, and charming villa, vacation home, house, and houseboats.
Romantics, fortune-hunters, and dwellers who are smelling around vacation rental and are trying to originate condo rentals Grand Island New York, bed and breakfast rentals Grand Island, and rental home in Grand Island New York can grub our for rent by owner website and our well appointed indexes, log listed properties, oceanfront classified advertisements, and lakeside classified ads.
Ascertain and design condo rentals and Bronx real estate rentals.
Find, find, and find house rentals Central Islip United States, apartments for rent in Central Islip United States, and homes for rent by owner Central Islip.
Light upon, espy, and identify Hughsonville United States apartments for rent, rental houses Hughsonville United States, and bed and breakfast rentals Hughsonville United States.
Disclose and contrive Whitesville United States condo rentals and Whitesville United States vacation homes.
Perceive, invent, and detect Otsego New York condo rentals and rent house.
Catch and contrive Calcium rent houses and home rentals Calcium United States.
Grand Island New York neighborhood employs many landlords, property managers, and agents.
You can rifle through the lakefront classifieds, resort ad directories, secluded ad directories, and beach online MLS under Grand Island New York vacation homes, Grand Island New York rental home, and Grand Island bed and breakfast rentals.
Elicit strange and sundry brass tacks in Grand Island New York and specify vacation rental in Grand Island.
Ascertain, relocate, and glimpse apartments for rent, Greene United States bed and breakfast rentals, and Greene United States vacation homes.
Join, employ, gather, and induct tomorrow morning to inaugurate, enter upon, take up, and kick off on this stroll.
Observe, elicit, and come upon rent house in Queens and Queens New York vacation rental.
Explore, light upon, and invent Rockland real estate rentals, Rockland homes for rent by owner, and rental apartment in Rockland New York.
Dig up and determine Allegany New York vacation rental and rental homes in Allegany New York.
Discern, find out, and devise rent house, condo rentals in Billings United States, and Billings condos for rent.
You can light upon, learn, and relocate vacation homes for rent by owner in Grand Island New York and Grand Island New York homes for rent by owner.
Jasper homes for rent, homes for rent Jasper Texas, and Jasper Texas home rentals
Observe and find out condos for rent in West Sayville and West Sayville United States rental properties.
Our webpage can admit and obtain hidden listed properties, exotic ad directories, and beachfront listed properties private classified advertisements, beachfront online MLS, rustic directories, and convenient listings to stump your Grand Island New York passage.
Elicit and catch Montgomery rental home, condos for rent, rent houses Montgomery, and real estate rentals in Montgomery New York.
Find and ferret out short term rentals Tioga, Tioga New York rental homes, and homes for rent by owner in Tioga New York.
Goose Creek homes for rent by owner and real estate rentals Goose Creek
Elicit, light upon, and distinguish Hannacroix United States homes for rent, Hannacroix United States apartment rentals, and Hannacroix apartment rentals.
The Grand Island advertisements numerated and docketed on For Rent By Owner involve decadent cabin, mountain vacation home, decadent villa, and exclusive vacation home.
Come upon and distinguish apartments for rent and vacation rentals.
Ferret out and design rental properties Schoharie, Schoharie rental apartment, for rent by owner homes Schoharie, and home rentals in Schoharie New York.
Observe and debunk for rent by owner homes in Nassau New York and Nassau New York vacation rental.
FRBO.com does take in novel city waterfront, secluded, log, and mountain ranch, cabin, and duplexs.
Contrive, distinguish, and conceive Bemus Point United States home rentals, Bemus Point United States house rentals, and apartments for rent in Bemus Point United States.
|
|
