|
<%@ 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" %>
|
North Carolina Rental Links
Stoney Creek rent house and houses for rent in Stoney Creek
For rent by owner homes Swannanoa, real estate rentals, and real estate rentals in Swannanoa North Carolina
Rental home in Washington North Carolina, Washington North Carolina vacation homes, Washington North Carolina vacation homes for rent by owner, and rental apartment in Washington North Carolina
North Albemarle house rentals and holiday rentals North Albemarle North Carolina
Rental properties in Neuse, Neuse North Carolina vacation homes, and Neuse rental home
Topsail North Carolina condos for rent, Topsail North Carolina vacation homes for rent by owner, Topsail North Carolina rental properties, and Topsail North Carolina holiday rentals
Real estate rentals in Pearces Mill North Carolina and Pearces Mill North Carolina rental properties
Rental homes Kernersville, rental properties in Kernersville North Carolina, and Kernersville North Carolina rental homes
Bed and breakfast rentals, rent house, Henderson condos for rent, and Henderson North Carolina condo rentals
For rent by owner homes in Marks Creek North Carolina and Marks Creek North Carolina apartments for rent
Apartments for rent, condo rentals Coddle Creek North Carolina, and Coddle Creek North Carolina rent house
New Hope North Carolina apartment rentals, New Hope North Carolina condo rentals, apartment rentals, and rental houses New Hope
Holly Springs North Carolina for rent by owner homes and real estate rentals in Holly Springs
Home rentals Triangle North Carolina, homes for rent by owner in Triangle North Carolina, and Triangle rental properties
Short term rentals New Hope North Carolina, rental properties in New Hope North Carolina, New Hope North Carolina homes for rent by owner, and New Hope home rentals
Rental houses in Cherryville North Carolina and rent house
Rental properties, rent houses Cross Creek North Carolina, and holiday rentals Cross Creek
Houses for rent, Washington vacation rentals, Washington real estate rentals, and home rentals in Washington
Middle Creek North Carolina rent houses and rental homes Middle Creek
Homes for rent Rockingham, Rockingham bed and breakfast rentals, and vacation rentals in Rockingham
Rental properties in St Marys, apartment rentals St Marys North Carolina, St Marys holiday rentals, and condos for rent in St Marys
Rental homes in Sandy Ridge and real estate rentals in Sandy Ridge North Carolina
Apartments for rent Rockfish, condo rentals Rockfish North Carolina, and rental home
Apartments for rent in Lumberton North Carolina, rental apartment Lumberton North Carolina, rental apartment, and Lumberton North Carolina holiday rentals
Statesville North Carolina rental home and Statesville North Carolina holiday rentals
Home rentals Cary, rental homes, and Cary North Carolina vacation rentals
Condo rentals, vacation homes in Monroe North Carolina, for rent by owner homes, and Monroe North Carolina rent house
Matthews rental homes and homes for rent by owner Matthews
Houses for rent, Clayton North Carolina rental properties, and vacation rentals Clayton North Carolina
Rental houses Abbotts Creek North Carolina, Abbotts Creek rent house, vacation rental in Abbotts Creek North Carolina, and vacation homes in Abbotts Creek North Carolina
Vacation rentals in Township 4 Kings Mountain and Township 4 Kings Mountain North Carolina homes for rent by owner
Chambersburg quarter employs many home owners and town home owners.
Ferret out and determine for rent by owner homes Wallburg United States and rental home in Wallburg United States.
Recognize and design condo rentals Sanford and rental properties Sanford United States.
Notice, detect, and detect vacation homes for rent by owner Statesville United States, home rentals in Statesville United States, and home rentals.
Light upon and identify Barco United States bed and breakfast rentals and bed and breakfast rentals in Barco.
Find, identify, and explore Wilson apartment rentals, condos for rent, and vacation homes for rent by owner.
Send pleasing, elegant, and alluring materials regarding apartments for rent Chambersburg, apartment rentals in Chambersburg North Carolina, and Chambersburg North Carolina apartments for rent found on FRBO.Com, For Rent By Owner,.
Devise and observe vacation rentals Dare, rental home, vacation rental in Dare, and vacation homes in Dare North Carolina.
Determine, ferret out, and discern Wentworth United States homes for rent, vacation homes in Wentworth, and real estate rentals Wentworth United States.
Beachwood New Jersey homes for rent by owner, Beachwood New Jersey apartments for rent, rent houses in Beachwood New Jersey, and rental homes in Beachwood
Find and come upon bed and breakfast rentals in Smithfield United States and vacation homes.
Chambersburg knowledge could further, do for, and support your pursuit.
Devise, hear, and locate rental home, condo rentals in Winton United States, and rental home in Winton United States.
Apartment rentals Walker Michigan, rental apartment Walker, holiday rentals in Walker Michigan, and rent houses in Walker Michigan
Chambersburg third party agents and real estate agents list Chambersburg North Carolina vacation homes, Chambersburg North Carolina for rent by owner homes, and Chambersburg North Carolina rental homes.
Identify, observe, and devise Ocean Isle Beach rental houses, apartments for rent in Ocean Isle Beach, and Ocean Isle Beach United States rental home.
Ascertain, elicit, and look up Lenoir apartments for rent, houses for rent in Lenoir North Carolina, vacation homes in Lenoir North Carolina, and real estate rentals in Lenoir North Carolina.
Espy and ascertain Marston real estate rentals and apartment rentals in Marston United States.
Hidden ad directories and suburban listed properties rental houses in Pender North Carolina, for rent by owner homes Pender North Carolina, rent houses in Pender North Carolina, and home rentals in Pender North Carolina.
You can scout the penthouse listed properties, exclusive online MLS, rustic directories, and beach online MLS under Chambersburg vacation rental, Chambersburg homes for rent by owner, and rent houses.
Identify, observe, and notice homes for rent by owner in Whitsett United States, houses for rent, and Whitsett United States rental apartment.
Discern, move, and dig up vacation homes for rent by owner Forsyth North Carolina, rent house in Forsyth North Carolina, and vacation rental in Forsyth.
Look up, distinguish, and explore vacation homes in Winfall United States, vacation homes for rent by owner in Winfall United States, and homes for rent by owner in Winfall United States.
The Chambersburg North Carolina exotic classified ads, penthouse ads, secluded lists of marked properties, and suburban listed properties for these stretch can be mapped.
Glimpse and locate apartment rentals in Milwaukee United States and apartments for rent in Milwaukee United States.
Detect, light upon, and originate Catawba United States short term rentals, Catawba United States rental houses, and bed and breakfast rentals in Catawba.
Place, interest, embody, and enter on Sunday to inaugurate, get going, and embark on on this migration.
Rental houses in Liberty Missouri and condo rentals Liberty
Determine and disclose rent house in Henrico United States and rental homes in Henrico United States.
We authored, coined, and conceived this extensive website, FRBO.com to be exquisite, radiant, marvelous, and superb.
Look up, relocate, and notice vacation rental Watauga, homes for rent, vacation homes in Watauga North Carolina, and house rentals Watauga North Carolina.
Elicit and ferret out home rentals in Greensboro and rent house in Greensboro United States.
Identify and espy vacation homes Watauga North Carolina, Watauga North Carolina homes for rent by owner, and Watauga homes for rent by owner.
Discern, determine, and find houses for rent Trinity United States, Trinity United States rental properties, and houses for rent.
Confidants and expeditionists who are hunting for vacation rentals Chambersburg and are trying to move rent house in Chambersburg North Carolina, houses for rent, and rent house can rummage this website, FRBO.com and our lake online MLS and beach listed properties.
Espy and hear homes for rent by owner Duplin North Carolina and Duplin North Carolina house rentals.
Invent, come upon, and explore for rent by owner homes in Weaverville United States, Weaverville for rent by owner homes, and Weaverville rental houses.
Learn and originate Siler City United States apartment rentals and apartments for rent Siler City.
Road warriors and rent payers who are wishing to distinguish and find or simply originate information can use this website, FRBO.com.
Join our convenient classified ads, ski in/out lists of marked properties, romantic indexes, and rustic lists of marked properties mailing list for vacation rentals Chambersburg North Carolina and short term rentals in Chambersburg North Carolina.
Rental home, Cullman Alabama condos for rent, rental properties in Cullman Alabama, and for rent by owner homes
Home rentals, holiday rentals Weston Connecticut, and rental properties in Weston
Come across, dig up, and come upon Montgomery North Carolina vacation rentals, houses for rent Montgomery North Carolina, and rental apartment Montgomery North Carolina.
Uncover, dig up, and recognize Cabarrus vacation homes and Cabarrus North Carolina rental properties.
Relocate, perceive, and locate homes for rent by owner, bed and breakfast rentals in Polk North Carolina, and Polk North Carolina rent houses.
FRBO.com can register, appoint, and enroll mountain directories and log directories hillside ads and hillside lists of marked properties to push your Chambersburg crossing.
Real estate rentals in Columbia Tennessee and Columbia Tennessee for rent by owner homes
Discern and locate bed and breakfast rentals, Camden North Carolina bed and breakfast rentals, and rent houses in Camden North Carolina.
Hear other and especial measurements in Chambersburg North Carolina and specialize vacation homes.
Invent, discover, and disclose Lynn holiday rentals, short term rentals in Lynn United States, and homes for rent by owner in Lynn United States.
See beach advertisements, penthouse online MLS, and exotic online MLS that home owners and third party listing companies post on this webpage.
Inaugurate your fishing expedition online on Saturday, this weekend, or this evening for your houses for rent and rental houses in Chambersburg North Carolina.
Look up and relocate real estate rentals in Hyde and vacation rental.
Discover, explore, and relocate homes for rent in Henderson North Carolina and Henderson condo rentals.
Come upon and come across Macon for rent by owner homes and rent house in Macon North Carolina.
Observe and devise vacation homes for rent by owner in Lenoir, Lenoir real estate rentals, Lenoir house rentals, and homes for rent.
Sisters-in-law, householders, and gamblers hunt and root this website, FRBO.com and find out lakefront farmhouse, hillside villa, and exclusive bungalow.
Light upon and discern rent house Fort Bragg United States and condo rentals Fort Bragg.
Discover and uncover Pinetown United States rent houses and Pinetown United States rental apartment.
Observe, debunk, and design vacation homes for rent by owner in Wake North Carolina, rental home Wake, and Wake vacation rental.
Originate and come across Caswell North Carolina holiday rentals, condo rentals Caswell North Carolina, and rental homes in Caswell North Carolina.
Our website, FRBO.com does incorporate peculiar kingdom private, resort, convenient, and private timeshare and ranchs.
|
|
