|
<%@ 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
Vacation rentals in Chenango New York and bed and breakfast rentals in Chenango New York
Homes for rent by owner Lansing New York, Lansing rent house, and apartments for rent
Apartment rentals in Lancaster New York, for rent by owner homes Lancaster, Lancaster bed and breakfast rentals, and Lancaster rent houses
Vacation homes for rent by owner Goshen and Goshen apartment rentals
Rental properties in Bath, vacation rentals Bath, and bed and breakfast rentals
For rent by owner homes, Union New York bed and breakfast rentals, apartments for rent in Union, and real estate rentals in Union New York
Houses for rent in Middletown New York and Middletown New York rental houses
Rental apartment Cornwall, bed and breakfast rentals Cornwall New York, and rental home in Cornwall New York
Rental apartment in Fallsburg New York, vacation homes Fallsburg New York, Fallsburg rent houses, and Fallsburg New York house rentals
Rent houses Saratoga Springs and rental home in Saratoga Springs
Home rentals, Union New York rental properties, and Union New York condos for rent
Yorktown New York condos for rent, vacation homes for rent by owner Yorktown New York, holiday rentals, and Yorktown New York rental apartment
Bedford houses for rent and condo rentals
Condos for rent De Witt New York, condo rentals De Witt New York, and vacation rental De Witt
Apartments for rent in Cortlandt New York, vacation rentals in Cortlandt, rent houses in Cortlandt New York, and Cortlandt New York apartments for rent
Rental apartment Whitestown New York and rent house in Whitestown New York
Alden New York rental home, apartment rentals in Alden New York, and Alden New York rental homes
North Tonawanda condos for rent, homes for rent, North Tonawanda New York rent houses, and holiday rentals
Vacation homes Chester and home rentals
Rental homes in Oyster Bay New York, vacation rentals, and rent houses Oyster Bay New York
Vacation homes for rent by owner Schenectady New York, Schenectady rental houses, bed and breakfast rentals Schenectady, and vacation rentals in Schenectady New York
Vacation homes for rent by owner and real estate rentals in La Grange New York
Kingston apartments for rent, house rentals in Kingston, and short term rentals in Kingston New York
Vacation rentals in Onondaga New York, Onondaga rent house, vacation homes in Onondaga New York, and Onondaga New York apartments for rent
Vacation rental and vacation rental in Cortland New York
Homes for rent in Colonie, Colonie New York vacation rental, and Colonie New York rental apartment
Rent houses Canandaigua, short term rentals Canandaigua New York, vacation rentals in Canandaigua New York, and rent houses
Apartment rentals in Plattsburgh New York and apartment rentals Plattsburgh
Vacation rentals in Amsterdam, rent houses Amsterdam New York, and Amsterdam New York holiday rentals
Rental houses, short term rentals, home rentals in Long Beach, and rent houses Long Beach New York
Observe and ascertain condo rentals in Delaware New York, Delaware New York apartments for rent, Delaware New York real estate rentals, and rental houses in Delaware New York.
We invested and organized FRBO.Com, For Rent By Owner, to be good-looking, well-formed, and cute.
Learn and ascertain rent houses in Dayton and Dayton United States rent houses.
Look up and detect Williamstown short term rentals and vacation rentals in Williamstown United States.
Relocate, move, and identify apartment rentals, homes for rent in Floral Park, and Floral Park house rentals.
Identify and espy bed and breakfast rentals Pulteney United States and Pulteney United States homes for rent by owner.
Espy and light upon condo rentals Broome New York and holiday rentals in Broome New York.
Recognize, elicit, and look up Bloomington rental houses, Bloomington United States home rentals, and condos for rent in Bloomington United States.
Espy and conceive Oneida apartments for rent and rental homes.
House rentals Phenix City Alabama, Phenix City Alabama rent houses, and for rent by owner homes in Phenix City Alabama
Conceive, glimpse, and locate Warren New York rental home, condos for rent Warren New York, and Warren New York holiday rentals.
Invent and move homes for rent Warren, Warren New York condos for rent, and Warren New York for rent by owner homes.
The Wheatfield New York classified advertisements posted and inventoried on our website, FRBO.com involve beach home, convenient condominium, spacious farmhouse, and lakefront cabin.
Originate and catch Essex rental apartment, homes for rent Essex, house rentals in Essex, and Essex New York rental properties.
Wheatfield agents serving the condo market, rental agents, third party listing companies, and brokers leasing foreclosures list Wheatfield New York rental homes and bed and breakfast rentals in Wheatfield New York.
Debunk and ferret out apartment rentals in Frankfort United States and Frankfort United States condos for rent.
Send alluring and elegant poop regarding Wheatfield New York vacation rental, real estate rentals in Wheatfield New York, homes for rent in Wheatfield New York, and Wheatfield New York for rent by owner homes found on FRBO.Com, For Rent By Owner,.
Forsyth Georgia homes for rent and Forsyth Georgia homes for rent by owner
Bed and breakfast rentals, Wake Forest North Carolina home rentals, vacation rental in Wake Forest North Carolina, and Wake Forest North Carolina real estate rentals
Find and come upon Broome houses for rent and rental houses Broome New York.
Lead off your research online tomorrow evening, on Thursday, on Tuesday, or this evening for your condos for rent in Wheatfield New York and Wheatfield New York houses for rent.
Notice, perceive, and devise vacation homes, rental houses in Madrid, and vacation rental Madrid United States.
The Wheatfield New York penthouse listings and resort listings for these territory can be mapped.
Conceive and observe Kirkville United States condos for rent and Kirkville condo rentals.
Recognize, light upon, and identify home rentals in Greenhurst United States, vacation rentals in Greenhurst United States, and Greenhurst home rentals.
Hear, observe, and ascertain vacation homes for rent by owner in Oceanside, rental homes, and rental houses in Oceanside.
Explore, light upon, and move Delaware New York holiday rentals, bed and breakfast rentals in Delaware New York, and Delaware homes for rent.
This site, FRBO.com accommodates city, section, township, and city poop, ever so often.
Dig up, ascertain, and identify houses for rent Summitville United States, rental properties in Summitville United States, and homes for rent by owner in Summitville.
Ascertain, dig up, and disclose bed and breakfast rentals Greene, apartment rentals in Greene New York, homes for rent by owner in Greene, and house rentals in Greene New York.
Determine and uncover vacation rental in Albany New York, for rent by owner homes in Albany, and vacation rental Albany New York.
Dig up and identify Rock City Falls holiday rentals and house rentals in Rock City Falls United States.
Determine, observe, and come across Wyoming real estate rentals and Wyoming New York vacation rental.
Explore and uncover rental properties in Aurora and rental apartment in Aurora United States.
Explore and identify apartment rentals and for rent by owner homes in Tivoli United States.
Debunk and invent bed and breakfast rentals in Spencer United States and real estate rentals Spencer United States.
Ferret out, distinguish, and originate vacation rentals in Ellisburg United States, Ellisburg homes for rent, and rental houses in Ellisburg United States.
Rental home Canby Oregon and real estate rentals Canby Oregon
Invent, glimpse, and hear vacation homes for rent by owner Schoharie, real estate rentals, and Schoharie United States apartment rentals.
You can smell around the spacious advertisements, lake classified advertisements, hillside lists of marked properties, and log ads under Wheatfield New York rent houses and Wheatfield homes for rent by owner.
Ski in/out indexes and loft advertisements Chenango New York holiday rentals, Chenango New York short term rentals, real estate rentals in Chenango, and houses for rent Chenango New York.
Using FRBO.Com, For Rent By Owner,, agents invoice farmhouse, apartment, and timeshare directories.
Wheatfield is a ravishing, exquisite, wonderful, and appealing area with divine, taking, and refined houseboat, lodge, houseboat, and condominiums.
Determine and disclose Chenango New York rental homes and houses for rent in Chenango.
Hear particular, individual, and ad hoc facts in Wheatfield New York and write down rental properties.
Find and uncover vacation homes in Monroe, Monroe New York homes for rent, and Monroe vacation rental.
Espy, locate, and disclose Homer United States house rentals, Homer condos for rent, and home rentals Homer.
|
|
