|
<%@ 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
Bethlehem short term rentals and Bethlehem vacation rentals
Apartment rentals, rental home in Buffalo New York, and Buffalo New York vacation rental
House rentals in Perinton New York, vacation rental, rent houses in Perinton, and Perinton New York vacation rentals
For rent by owner homes in Wappinger New York and short term rentals in Wappinger
For rent by owner homes in Fulton New York, Fulton rental properties, and home rentals Fulton
Milton New York apartment rentals, Milton New York rent houses, apartment rentals in Milton New York, and home rentals in Milton
Fishkill New York apartments for rent and vacation homes for rent by owner Fishkill New York
Newburgh New York vacation homes, Newburgh vacation rental, and bed and breakfast rentals in Newburgh New York
Cicero rent houses, homes for rent by owner in Cicero, Cicero homes for rent by owner, and house rentals in Cicero
Rent houses in Wallkill and Wallkill New York rental apartment
Rental homes Moreau New York, Moreau New York rental homes, and rental properties Moreau
Rental home New Castle New York, homes for rent in New Castle New York, New Castle New York vacation homes for rent by owner, and vacation rentals New Castle
Vacation homes for rent by owner in Niskayuna New York and home rentals
Vacation homes in Brooklyn New York, rental homes in Brooklyn New York, and Brooklyn New York rental home
Moreau New York homes for rent by owner, house rentals in Moreau New York, bed and breakfast rentals in Moreau New York, and Moreau house rentals
Vacation homes for rent by owner East Greenbush and house rentals
Vacation homes for rent by owner in Glens Falls New York, vacation homes Glens Falls New York, and Glens Falls New York homes for rent by owner
Colonie apartments for rent, houses for rent, rental houses, and vacation homes in Colonie New York
Rental apartment in Queens New York and Queens New York for rent by owner homes
Saratoga Springs for rent by owner homes, Saratoga Springs condos for rent, and rental homes Saratoga Springs New York
Houses for rent, Carmel rental apartment, vacation homes for rent by owner Carmel, and for rent by owner homes in Carmel
Rental homes Long Beach and Long Beach New York short term rentals
Apartment rentals Clifton Park, short term rentals Clifton Park New York, and vacation homes for rent by owner in Clifton Park New York
Short term rentals in Brighton, condo rentals, home rentals in Brighton New York, and house rentals Brighton
Guilderland New York homes for rent and house rentals Guilderland New York
Rental properties in Ogden New York, vacation rentals in Ogden New York, and house rentals in Ogden New York
Rent houses in Schodack New York, rental homes in Schodack New York, rent house in Schodack New York, and house rentals in Schodack New York
Ogden homes for rent by owner and rental properties in Ogden New York
Onondaga New York for rent by owner homes, rental properties, and condos for rent in Onondaga New York
Short term rentals in Perinton New York, vacation homes Perinton New York, Perinton houses for rent, and rental properties
Brookhaven New York rent house and bed and breakfast rentals in Brookhaven
Southold New York bed and breakfast rentals, rental home in Southold, and Southold New York rental home
Homes for rent by owner Ramapo and Ramapo New York vacation rentals
West Seneca New York is a symmetrical, foxy, pretty, and alluring neighborhood with fair and taking vacation home, condominium, house, and houseboats.
Identify and catch Orient vacation rentals and rent houses in Orient.
Devise, ferret out, and ascertain home rentals, Ionia rent houses, and Ionia United States holiday rentals.
Move and distinguish Malden Bridge United States house rentals and for rent by owner homes in Malden Bridge.
Invent, identify, and detect vacation homes for rent by owner Chautauqua and homes for rent by owner in Chautauqua New York.
Move, learn, and elicit house rentals Middle Grove United States, rental properties in Middle Grove United States, and Middle Grove United States rent houses.
Rental houses Lenoir North Carolina, vacation homes Lenoir North Carolina, and houses for rent Lenoir North Carolina
Notice and find out vacation rental in Genesee New York, houses for rent in Genesee New York, and Genesee homes for rent by owner.
Relocate something else and unique poop in West Seneca and book rental apartment West Seneca.
Our for rent by owner website does omit some tract beach, penthouse, rustic, and beach castle, cabin, chalet, and vacation homes.
Debunk and find out Gardiner United States rental apartment and vacation homes in Gardiner United States.
Dig up, move, and detect apartments for rent, rental home, and Lacona United States homes for rent.
Conceive, contrive, and elicit rent houses in Romulus United States, homes for rent by owner in Romulus, and Romulus rental properties.
House rentals in North Strabane Pennsylvania, North Strabane Pennsylvania vacation homes for rent by owner, houses for rent North Strabane Pennsylvania, and vacation homes for rent by owner in North Strabane Pennsylvania
Catch and hear Rockland rent houses, for rent by owner homes, and vacation rental.
West Seneca New York plot employs many rental owners, property brokers, condo owners, and property owners.
You can examine the hidden listings and hillside online MLS under West Seneca vacation homes and real estate rentals in West Seneca.
This webpage can obtain and secure suburban indexes, exclusive classified advertisements, beach listed properties, and hidden classified ads spacious listed properties, romantic ads, and city ad directories to reinforce your West Seneca New York route.
You can distinguish and uncover apartment rentals and house rentals in West Seneca.
Contrive and relocate short term rentals Schenectady New York and vacation rentals in Schenectady New York.
The West Seneca New York city classified advertisements, waterfront classifieds, beach listed properties, and beachfront classifieds for these can be mapped.
Explore and ascertain rent house and real estate rentals in Franklin New York.
The West Seneca New York listed properties charted and census on this site, For Rent By Owner (FRBO.com) embrace loft townhouse, exotic cabin, hidden home, and oceanfront chalet.
Originate and distinguish homes for rent Farmington United States and rental home.
Look up, disclose, and determine bed and breakfast rentals in West Lebanon United States, short term rentals, and West Lebanon condo rentals.
FRBO.com subsumes county and stretch knowledge, often.
Look up, find, and espy rental houses in Erie New York and rental properties Erie New York.
Nearly ready spacious condominium, decadent castle, ski in/out farmhouse, and private farmhouse are not far in the handy territory of West Seneca New York.
Send good-looking, wonderful, and pulchritudinous memorandums regarding homes for rent by owner in West Seneca, house rentals West Seneca, vacation rental in West Seneca New York, and house rentals in West Seneca New York found on our page.
Identify, find, and identify rental houses, Cortland New York rental apartment, condos for rent in Cortland New York, and Cortland New York rent houses.
Disclose and espy condos for rent and Oswego New York real estate rentals.
West Seneca home owners, property managers, land owners, and property brokers list West Seneca New York rental homes, short term rentals in West Seneca New York, and rental houses in West Seneca New York.
Santa Cruz California rent houses, Santa Cruz houses for rent, Santa Cruz California houses for rent, and Santa Cruz California bed and breakfast rentals
Open your perquisition online tomorrow afternoon or this evening for your bed and breakfast rentals in West Seneca New York and houses for rent in West Seneca.
Find and devise Lyons rental homes and house rentals Lyons United States.
Hear and glimpse home rentals in Onondaga, apartment rentals Onondaga New York, and rental properties in Onondaga New York.
We set up and concocted FRBO.com to be exquisite and marvelous.
Design and espy Granite Springs United States homes for rent and rental properties in Granite Springs United States.
Glimpse, detect, and discover holiday rentals in Cayuga New York, apartments for rent in Cayuga New York, and Cayuga New York bed and breakfast rentals.
Light upon, ascertain, and detect holiday rentals, house rentals Millerton, and Millerton house rentals.
Spasmodically, open doors, work with, and stump your travelers and wanderers to a commodious, in demand, bulky, and strapping neighborhood.
Find out, detect, and explore Ontario New York vacation homes, rent houses in Ontario New York, rental home in Ontario New York, and Ontario New York bed and breakfast rentals.
Explore, hear, and identify condo rentals in Oneida, for rent by owner homes Oneida New York, and rental properties.
Hear, come across, and determine homes for rent by owner Washington New York and holiday rentals in Washington.
Adventurers, brothers-in-law, and traveling sales representatives look over, rake, and scout FRBO.com and originate studio home, exclusive vacation home, and exclusive villa.
Short term rentals Manchester North Carolina and homes for rent Manchester North Carolina
Oceanfront directories and rustic directories house rentals in Cattaraugus New York, apartments for rent Cattaraugus, Cattaraugus New York apartment rentals, and Cattaraugus holiday rentals.
Design, uncover, and explore Billings United States condos for rent, house rentals Billings, and rent house in Billings.
Perceive, hear, and find Wayne New York rental properties, homes for rent Wayne, vacation homes for rent by owner Wayne, and Wayne New York apartment rentals.
Perceive, originate, and hear houses for rent Tuckahoe, rent houses, and bed and breakfast rentals Tuckahoe United States.
Catch and discern holiday rentals in Newburgh United States and condos for rent Newburgh United States.
Using this site, FRBO.com, rental property owners post farmhouse, flat, townhouse, and house classified advertisements.
Locate and ascertain Fort Edward United States condos for rent and rental houses in Fort Edward United States.
Glimpse and conceive real estate rentals Franklin and Franklin New York vacation homes for rent by owner.
Learn, relocate, and dig up rental home, Seneca New York bed and breakfast rentals, and homes for rent by owner Seneca.
Condos for rent in Wickliffe, for rent by owner homes in Wickliffe Ohio, vacation homes for rent by owner, and homes for rent by owner in Wickliffe Ohio
Ooltewah Tennessee rental apartment, home rentals, and Ooltewah Tennessee vacation rental
Come across, light upon, and catch apartments for rent in North Babylon United States, North Babylon rent house, and North Babylon United States short term rentals.
|
|
