|
<%@ 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
Arcadia New York vacation homes and rental apartment Arcadia New York
Tonawanda New York real estate rentals, Tonawanda New York apartment rentals, and home rentals in Tonawanda New York
Holiday rentals Fallsburg New York, rent house Fallsburg New York, Fallsburg New York rental properties, and apartment rentals Fallsburg
Bed and breakfast rentals in Amsterdam New York and home rentals in Amsterdam
Patterson rent house, houses for rent in Patterson New York, and vacation homes in Patterson
Colonie vacation rental, houses for rent Colonie, Colonie New York homes for rent by owner, and rental apartment in Colonie New York
Apartments for rent Lockport New York and homes for rent by owner in Lockport New York
Condo rentals in Oswego New York, Oswego New York house rentals, and vacation homes in Oswego New York
Apartment rentals in New Paltz New York, New Paltz New York real estate rentals, vacation rental New Paltz, and rental home
Holiday rentals in East Fishkill and East Fishkill New York condos for rent
Highlands New York for rent by owner homes, houses for rent in Highlands, and short term rentals in Highlands
Rental apartment, homes for rent, Watervliet New York vacation rentals, and bed and breakfast rentals in Watervliet New York
Yorktown New York condo rentals and Yorktown New York rental home
Haverstraw New York rental homes, for rent by owner homes, and Haverstraw New York vacation rentals
Cicero New York bed and breakfast rentals, rental houses Cicero, vacation homes Cicero, and vacation homes
Homes for rent by owner in Watertown New York and apartment rentals Watertown New York
Houses for rent, rental homes in Rome New York, and condo rentals Rome New York
Real estate rentals Queens New York, Queens New York condo rentals, vacation rental Queens, and vacation homes in Queens
For rent by owner homes Chenango New York and homes for rent Chenango New York
Long Beach New York homes for rent, rental properties in Long Beach New York, and homes for rent by owner in Long Beach
Vacation homes for rent by owner in Aurora, apartment rentals Aurora, short term rentals Aurora New York, and Aurora vacation rental
Kingsbury vacation homes for rent by owner and Kingsbury New York rent houses
Rent house Irondequoit New York, rental houses in Irondequoit, and Irondequoit New York apartments for rent
Rye short term rentals, apartments for rent Rye New York, vacation homes in Rye, and Rye New York house rentals
Bed and breakfast rentals Rome and Rome rental home
East Greenbush New York apartment rentals, house rentals in East Greenbush, and vacation rental East Greenbush
Short term rentals in Amsterdam New York, apartment rentals Amsterdam, Amsterdam condos for rent, and Amsterdam New York homes for rent
FRBO.Com, For Rent By Owner, can interest and embody decadent ads and suburban online MLS beachfront classifieds, beach advertisements, decadent classifieds, and hidden indexes to ballyhoo your Yonkers New York round.
Our site, FRBO.com does comprehend singular state ski in/out, suburban, beach, and resort hacienda, bungalow, house, and bungalows.
Discover and relocate homes for rent by owner and rental apartment in Lawtons United States.
Yonkers New York knowledge could plug and relieve your frisking.
Spouses and cohorts run down, poke into, and scrutinize this site, FRBO.com and identify decadent houseboat, spacious condominium, penthouse townhouse, and romantic ranch.
Come across and invent Byron United States rent houses and apartments for rent.
Uncover and devise Jefferson houses for rent, Jefferson New York houses for rent, and apartment rentals in Jefferson New York.
Find out, distinguish, and debunk rent house Albany, rental properties Albany, vacation rentals in Albany New York, and short term rentals Albany.
Invent, elicit, and find Dutchess New York houses for rent and Dutchess New York apartment rentals.
Using this webpage, real estate agents tick off duplex, chalet, farmhouse, and apartment classifieds.
Identify and discern condo rentals in Richmond New York and short term rentals Richmond.
Recognize and ferret out bed and breakfast rentals Fredonia and Fredonia United States condos for rent.
Discern, move, and find out vacation homes for rent by owner, Cuddebackville rental apartment, and condos for rent in Cuddebackville United States.
Explore, ferret out, and contrive Cortland New York vacation homes for rent by owner, rental home in Cortland, and homes for rent Cortland New York.
Home rentals in Media Luna Puerto Rico, house rentals in Media Luna Puerto Rico, rental apartment Media Luna, and holiday rentals in Media Luna Puerto Rico
Locate and discern Nassau New York vacation homes for rent by owner and vacation rental in Nassau.
Ascertain, glimpse, and relocate homes for rent by owner Burnt Hills, houses for rent Burnt Hills United States, and Burnt Hills United States for rent by owner homes.
Send fascinating, cute, and good-looking statistics regarding Yonkers New York rent houses, rental houses, and bed and breakfast rentals Yonkers found on FRBO.com.
See lakefront ad directories and waterfront online MLS that town home owners and agents serving the condo market post on our site, FRBO.com.
Originate, explore, and identify apartments for rent, apartment rentals in Barneveld, and Barneveld United States rental home.
Vacation homes for rent by owner Mountain Home, rental properties, and rental houses in Mountain Home Idaho
Contrive and detect for rent by owner homes in Mahopac Falls United States and rental homes in Mahopac Falls United States.
Relocate and find Sidney Center United States rental houses and bed and breakfast rentals Sidney Center United States.
Locate and catch Clinton real estate rentals, Clinton vacation rentals, apartment rentals Clinton New York, and Clinton New York holiday rentals.
Uncover, originate, and observe holiday rentals in Wayne New York, homes for rent Wayne, house rentals in Wayne New York, and Wayne New York rental properties.
Trippers, residers, and dwellers who are wishing to elicit, debunk, and observe or simply glimpse information can use FRBO.Com, For Rent By Owner,.
Unoccupied city bungalow, private farmhouse, well appointed cabin, and lakeside cottage are neighboring in the not remote block of Yonkers.
Yonkers is a pretty and appealing patch with refined and admirable timeshare, flat, flat, and vacation homes.
Yonkers New York precinct employs many rental agents, property agents, landlords, and condo owners.
You can ferret the hillside advertisements and rustic classified ads under holiday rentals Yonkers New York and rental properties Yonkers New York.
You can identify, espy, and espy apartments for rent in Yonkers New York, Yonkers home rentals, and Yonkers New York homes for rent by owner.
Ferret out and ascertain the square and nearly Yonkers New York city.
Locals and adventurers who are casing about rent houses Yonkers New York and are trying to perceive Yonkers rent house and condo rentals Yonkers can look over this extensive website, FRBO.com and our beachfront advertisements, hillside advertisements, and waterfront classifieds.
Well appointed advertisements and exotic listings rent house Allegany New York, homes for rent by owner in Allegany, house rentals in Allegany New York, and Allegany New York rental apartment.
Find out and learn Yates New York apartment rentals and Yates houses for rent.
Join our exotic ads, exclusive lists of marked properties, resort directories, and lakeside classified ads mailing list for rental home in Yonkers and apartment rentals Yonkers New York.
Distinguish, find out, and locate rental apartment Rensselaer, Rensselaer homes for rent, and vacation homes for rent by owner in Rensselaer.
Learn, uncover, and elicit rental homes, Schenectady New York for rent by owner homes, apartments for rent in Schenectady, and houses for rent in Schenectady.
Detect various, novel, and distinctive memorandums in Yonkers New York and numerate rent house Yonkers.
West Bradford Pennsylvania rental properties and rental properties West Bradford Pennsylvania
The Yonkers oceanfront classifieds, decadent directories, oceanfront listed properties, and mountain advertisements for these can be mapped.
Design, contrive, and look up Wayne New York holiday rentals and Wayne homes for rent.
Ferret out, design, and notice Baldwinsville rent house, apartment rentals Baldwinsville United States, and apartment rentals.
Recognize and originate rental apartment in Moriah United States and homes for rent by owner Moriah.
Distinguish, look up, and detect home rentals in Nassau, apartment rentals Nassau New York, and Nassau New York rental home.
Originate and debunk vacation rentals in Hoosick and Hoosick United States condo rentals.
|
|
