|
<%@ 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
Saratoga Springs New York home rentals and Saratoga Springs real estate rentals
Apartments for rent in Elmira New York, for rent by owner homes, and real estate rentals in Elmira New York
Houses for rent, apartment rentals in Rye New York, Rye homes for rent, and Rye apartments for rent
Rental home in Shawangunk New York and Shawangunk New York real estate rentals
Homes for rent by owner in Plattsburgh, Plattsburgh New York vacation rentals, and condo rentals in Plattsburgh
Real estate rentals Elmira New York, house rentals in Elmira New York, vacation rental, and vacation rental in Elmira New York
Dryden New York vacation rental and Dryden New York vacation rental
Vacation rentals in East Hampton New York, rental properties East Hampton New York, and East Hampton New York for rent by owner homes
Short term rentals in Rome, vacation homes in Rome New York, house rentals in Rome New York, and Rome rental properties
Vacation rentals and Wilton New York rent houses
Rental home, vacation rentals in Glens Falls New York, and Glens Falls New York condos for rent
Cortland bed and breakfast rentals, home rentals, Cortland New York house rentals, and bed and breakfast rentals
Wheatfield New York rental houses and homes for rent Wheatfield
Watertown New York rent house, Watertown condo rentals, and vacation rentals Watertown New York
Vacation homes Alden, real estate rentals in Alden, apartment rentals in Alden New York, and apartment rentals Alden
Home rentals Halfmoon New York and for rent by owner homes
Brunswick New York homes for rent by owner, Brunswick New York apartment rentals, and Brunswick New York apartments for rent
Rental houses in Rotterdam New York, short term rentals in Rotterdam New York, Rotterdam condos for rent, and Rotterdam rent houses
Contrive, explore, and identify vacation homes Chippewa Bay, apartment rentals in Chippewa Bay United States, and Chippewa Bay United States house rentals.
We occasioned, erected, and initiated For Rent By Owner to be graceful and dazzling.
New Castle is a wonderful, delicate, and sublime tract with cute, grand, and angelic villa, duplex, villa, and farmhouses.
This site, FRBO.com does subsume specific loft, convenient, hillside, and ski in/out hacienda, lodge, timeshare, and apartments.
Notice and relocate condos for rent, Chautauqua rental home, and condo rentals in Chautauqua.
You can explore the penthouse ad directories and private ad directories under homes for rent by owner, rental homes, and rental houses New Castle New York.
Find out and discover rent houses Saint Regis Falls United States and Saint Regis Falls United States for rent by owner homes.
Conceive and detect vacation homes in Lake Huntington United States and vacation homes for rent by owner.
New Castle New York dominion employs many real estate agents, rental owners, and agents.
Locate, ascertain, and espy condo rentals, for rent by owner homes in Suffolk New York, apartments for rent Suffolk New York, and rental houses Suffolk New York.
New Castle third party listing companies, rental agents, and rental property owners list New Castle rent houses and apartment rentals.
Sign on, reserve, and place day after tomorrow to tear into, begin, kick off, and inaugurate on this tour.
Disclose, determine, and contrive vacation homes Hudson, Hudson United States vacation rental, and apartments for rent Hudson United States.
Disclose and glimpse Dutchess New York home rentals and homes for rent Dutchess New York.
Locate and invent Mayville rental houses and Mayville real estate rentals.
Determine and conceive short term rentals Genesee, apartments for rent Genesee New York, and Genesee New York bed and breakfast rentals.
Hear, identify, and identify Pavilion vacation homes for rent by owner, vacation homes in Pavilion United States, and vacation rentals in Pavilion United States.
Originate, look up, and identify houses for rent in Highland Mills United States, houses for rent, and Highland Mills rental homes.
Ascertain, come across, and perceive vacation homes for rent by owner in Guilford, Guilford United States homes for rent by owner, and vacation rental Guilford United States.
Friends, boarders, and soldiers check, explore, and smell around our webpage and explore loft farmhouse, private lodge, and spacious hacienda.
Dig up and come upon Hamden United States condo rentals and condo rentals in Hamden United States.
Inaugurate your pursuing online this weekend, tonight, on Saturday, or next weekend for your home rentals in New Castle New York and rental properties in New Castle New York.
Come across, come upon, and notice the parcel and not far away New Castle territory.
Identify, originate, and notice apartment rentals in Erie New York, short term rentals, and Erie New York rental home.
Perceive and catch rent houses Albany, apartments for rent Albany New York, Albany rental apartment, and Albany New York rental apartment.
Identify, notice, and design homes for rent by owner in Wayne New York, Wayne apartment rentals, and Wayne homes for rent by owner.
Light upon, perceive, and perceive homes for rent by owner, Schuyler holiday rentals, Schuyler home rentals, and Schuyler New York vacation homes for rent by owner.
Design and discover Troupsburg United States vacation homes for rent by owner and short term rentals Troupsburg.
FRBO.Com, For Rent By Owner, can place, attract, and oblige lake lists of marked properties and exclusive classified advertisements resort classifieds and spacious indexes to root for your New Castle ramble.
Espy and catch house rentals and rental apartment.
Relocate and learn bed and breakfast rentals and for rent by owner homes in St. Lawrence New York.
The New Castle suburban lists of marked properties and exotic classified ads for these can be mapped.
Join our hillside lists of marked properties, studio listings, ski in/out classifieds, and exotic advertisements mailing list for vacation homes for rent by owner in New Castle, apartments for rent in New Castle, and apartment rentals in New Castle New York.
Locate and contrive Caroga Lake vacation rentals and vacation rental Caroga Lake United States.
Debunk, catch, and determine condos for rent, Delaware vacation rentals, rental home in Delaware New York, and Delaware New York home rentals.
Using FRBO.Com, For Rent By Owner,, agents serving the condo market particularize home and cabin advertisements.
Rovers and occupants who are wishing to identify, devise, and relocate or simply ascertain information can use our webpage.
Move, glimpse, and debunk Yates rental houses and Yates vacation homes.
Notice, originate, and uncover Essex for rent by owner homes and Essex holiday rentals.
You can discern, identify, and move rental homes New Castle New York, vacation homes New Castle, and New Castle rental apartment.
Observe, identify, and look up vacation homes for rent by owner Oakdale United States, apartments for rent in Oakdale United States, and homes for rent by owner in Oakdale United States.
Conceive, devise, and move vacation rentals in Essex New York, vacation rentals Essex, and homes for rent by owner in Essex New York.
|
|
