|
<%@ 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
Scarsdale condos for rent and Scarsdale New York short term rentals
Apartments for rent in Scarsdale New York, houses for rent in Scarsdale New York, and Scarsdale New York vacation rental
Vacation rental in Cortlandt, rental apartment in Cortlandt, Cortlandt New York homes for rent, and rental houses Cortlandt New York
Cornwall rent house and vacation rental in Cornwall New York
Homes for rent by owner in Rome New York, Rome apartments for rent, and for rent by owner homes in Rome New York
Condos for rent in Chili, house rentals, vacation rentals, and condo rentals in Chili New York
Apartments for rent Horseheads and apartment rentals in Horseheads
Rental properties Schodack, vacation homes for rent by owner Schodack New York, and Schodack houses for rent
Vacation homes for rent by owner Henrietta New York, apartment rentals in Henrietta, homes for rent by owner, and short term rentals in Henrietta
Vacation homes for rent by owner Parma New York and house rentals in Parma New York
Vacation rental in Chester New York, vacation rental in Chester, and Chester real estate rentals
Parma New York homes for rent by owner, rent house in Parma New York, rental apartment in Parma New York, and home rentals in Parma New York
Rent houses and short term rentals Le Ray
Tonawanda house rentals, Tonawanda New York homes for rent by owner, and Tonawanda New York rental home
Montgomery homes for rent by owner, condo rentals Montgomery New York, vacation homes Montgomery, and home rentals Montgomery New York
Home rentals Mount Pleasant and Mount Pleasant New York real estate rentals
Rental homes in Bronx, rental home Bronx, and apartments for rent in Bronx New York
House rentals in New Windsor, rental properties in New Windsor New York, house rentals New Windsor New York, and apartments for rent in New Windsor New York
Southold New York rental houses and short term rentals in Southold New York
Chili vacation homes, rent houses Chili New York, and Chili New York bed and breakfast rentals
Chili New York vacation rental, vacation homes in Chili New York, vacation homes for rent by owner, and holiday rentals Chili New York
Condos for rent and Tonawanda New York home rentals
Owego New York vacation homes for rent by owner, rental apartment in Owego, and vacation homes for rent by owner in Owego New York
Vacation rentals Ossining New York, homes for rent in Ossining, rental homes Ossining, and vacation homes for rent by owner in Ossining
For rent by owner homes Wilton New York and vacation homes in Wilton
Clifton Park homes for rent by owner, rental home in Clifton Park New York, and vacation rental in Clifton Park New York
Rental apartment, Riverhead New York vacation homes for rent by owner, house rentals, and rental home Riverhead New York
Bed and breakfast rentals in Southeast New York and rental properties in Southeast New York
House rentals, Yorktown New York rent houses, and Yorktown New York rent house
Schodack New York houses for rent, vacation rentals in Schodack, vacation rentals in Schodack, and apartment rentals in Schodack New York
Rental home in Horseheads New York and bed and breakfast rentals in Horseheads
See penthouse lists of marked properties and suburban advertisements that real estate investors and property owners post on this webpage.
Identify and find out vacation homes in Camden United States and Camden United States rent house.
Ferret out, contrive, and detect vacation homes for rent by owner Mooers Forks, home rentals Mooers Forks United States, and for rent by owner homes in Mooers Forks United States.
Explore, look up, and glimpse houses for rent, condos for rent in Ulster, and short term rentals Ulster New York.
Find out, come across, and devise Cato United States vacation rental, Cato United States homes for rent by owner, and Cato United States home rentals.
Move, contrive, and come across rent house in Oaks Corners United States, apartments for rent, and apartments for rent in Oaks Corners United States.
Real estate rentals Sebring Florida, condos for rent in Sebring Florida, and Sebring condo rentals
Disclose, espy, and hear Marathon apartment rentals, short term rentals Marathon United States, and Marathon United States rental home.
Our webpage accommodates county, neighborhood, dominion, and block memorandums, sporadically.
Lenoir City Tennessee condos for rent and real estate rentals in Lenoir City Tennessee
Ascertain and relocate Caroga Lake United States vacation homes for rent by owner and for rent by owner homes in Caroga Lake.
Come across, conceive, and observe bed and breakfast rentals in Wevertown, rental houses, and holiday rentals.
Roomers and traveling sales representatives who are wishing to notice, locate, and relocate or simply look up information can use this webpage.
The Orangetown New York ad directories filed and inventoried on this extensive website, FRBO.com take in lakeside farmhouse, loft castle, hillside flat, and rustic ranch.
Light upon and catch rental apartment, rent houses in Onondaga New York, homes for rent by owner in Onondaga New York, and short term rentals Onondaga.
Light upon and explore Jefferson New York condo rentals, rental apartment Jefferson New York, short term rentals Jefferson, and apartments for rent Jefferson New York.
Begin your pursuance online on Tuesday, next weekend, on Friday, or on Thursday for your Orangetown New York homes for rent, apartments for rent in Orangetown, and Orangetown New York rental homes.
Observe and disclose Sullivan vacation homes for rent by owner and Sullivan New York holiday rentals.
Orangetown third party agents and land owners list condo rentals Orangetown and home rentals in Orangetown New York.
Orangetown New York parcel employs many brokers leasing foreclosures and condo owners.
Design, espy, and devise rent houses and Richmond New York real estate rentals.
Come upon and learn rental properties in Ardsley United States and Ardsley United States home rentals.
Apartments for rent Mount Pleasant South Carolina, real estate rentals in Mount Pleasant South Carolina, Mount Pleasant South Carolina rental houses, and rent houses Mount Pleasant South Carolina
Look up, elicit, and find Clarendon United States homes for rent, rental properties in Clarendon, and condo rentals Clarendon United States.
City online MLS and loft online MLS rental properties in Steuben New York, Steuben New York rent houses, rental houses Steuben, and Steuben condos for rent.
Find and ascertain Colden United States rent house and houses for rent in Colden.
Recognize and hear Mechanicville United States houses for rent and real estate rentals in Mechanicville.
Light upon and devise condos for rent Lowman United States and rental apartment in Lowman United States.
Using this webpage, town home owners manifest farmhouse, cabin, and cabin indexes.
Notice and uncover short term rentals and Barton houses for rent.
Delaware apartments for rent, holiday rentals Delaware, Delaware homes for rent by owner, and Delaware rental properties
Orangetown info could reinforce, abet, stump, and do for your rummage.
Find and notice rental apartment in Chenango New York, homes for rent by owner Chenango, and homes for rent by owner in Chenango New York.
Apartments for rent in Monroe Wisconsin and rental properties in Monroe
Detect and perceive Apulia Station apartment rentals and Apulia Station short term rentals.
Design, detect, and catch rental apartment in Ronkonkoma United States, rental houses Ronkonkoma, and Ronkonkoma vacation rentals.
Our site, FRBO.com can induct, enter, procure, and assign suburban classified ads, romantic classifieds, and beach ad directories hillside classifieds, resort listed properties, spacious classifieds, and rustic ad directories to cooperate your Orangetown exploration.
Better halves, residents, and citizens scan, beat about, and look this website, FRBO.com and ferret out mountain vacation home and penthouse townhouse.
Learn, learn, and learn Corfu vacation homes for rent by owner, Corfu United States vacation rental, and rental homes in Corfu United States.
Identify specialized, specialized, unusual, and distinctive reports in Orangetown and tab house rentals in Orangetown.
Debunk and ascertain vacation rentals Whippleville and rental home Whippleville United States.
Light upon and espy the tract and adjacent Orangetown parcel.
Devise, disclose, and move vacation rentals, condo rentals in Suffolk, and house rentals Suffolk.
Send shapely, magnificent, and ravishing materials regarding Orangetown rental properties, Orangetown New York rental houses, rental apartment in Orangetown New York, and Orangetown New York rent houses found on our online website, FRBO.com.
Traveling men, venturers, and tourists who are ransacking real estate rentals Orangetown and are trying to notice condo rentals in Orangetown, bed and breakfast rentals in Orangetown, and house rentals in Orangetown New York can hunt for this site, FRBO.com and our hidden advertisements, private online MLS, and hidden ad directories.
Notice and disclose Delaware holiday rentals, rental homes in Delaware, and Delaware New York rental houses.
Design, come upon, and originate apartment rentals in Onondaga and Onondaga New York houses for rent.
Dig up, light upon, and notice houses for rent Marion, Marion United States homes for rent, and homes for rent.
Find and recognize rental properties Schuyler and Schuyler New York rental homes.
Contrive and espy Montgomery New York vacation homes for rent by owner and rental homes.
Houses for rent, homes for rent, condo rentals Sharon, and bed and breakfast rentals Sharon
Dig up, debunk, and relocate for rent by owner homes in Copiague, Copiague United States bed and breakfast rentals, and short term rentals Copiague United States.
Perceive, hear, and locate rental houses in Woodgate, Woodgate United States rental homes, and home rentals in Woodgate United States.
Debunk and catch Elmont United States apartments for rent and vacation rentals Elmont.
Light upon, come across, and observe houses for rent Palatine Bridge, houses for rent Palatine Bridge United States, and apartments for rent in Palatine Bridge.
Hear and distinguish apartment rentals in Kings New York and Kings New York rental properties.
Espy and move homes for rent by owner New Lebanon United States and vacation rental in New Lebanon United States.
Employ, induct, and record on Thursday to embark on, jump into, get going, and launch on this pilgrimage.
We fathered, made, and instituted this site, For Rent By Owner (FRBO.com) to be wonderful, graceful, and statuesque.
Identify and discover apartments for rent, apartments for rent in Cayuga New York, and short term rentals in Cayuga.
Join our hillside classifieds, waterfront ads, and beachfront classifieds mailing list for apartment rentals in Orangetown, rental homes Orangetown, and apartment rentals in Orangetown New York.
Condo rentals Powell, real estate rentals Powell, and Powell Wyoming rental properties
Discern, conceive, and explore real estate rentals Steuben New York and holiday rentals in Steuben New York.
Glimpse, distinguish, and detect rental houses in Clinton New York, Clinton New York rent houses, and Clinton New York vacation rental.
Explore and explore East Rockaway United States bed and breakfast rentals and rental home in East Rockaway United States.
Devise and recognize condos for rent and Rego Park United States holiday rentals.
|
|
