|
<%@ 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
Cary North Carolina rental properties and house rentals
House rentals Township 2 Poplar Tent North Carolina, rental home Township 2 Poplar Tent North Carolina, and vacation homes for rent by owner in Township 2 Poplar Tent North Carolina
Home rentals, Raeford North Carolina condos for rent, Raeford North Carolina bed and breakfast rentals, and Raeford rental properties
Home rentals in Matthews North Carolina and rental apartment in Matthews North Carolina
Rental houses White Oak North Carolina, homes for rent by owner in White Oak North Carolina, and rental homes in White Oak
Holiday rentals in Winterville, vacation homes in Winterville, Winterville North Carolina condos for rent, and apartment rentals in Winterville North Carolina
For rent by owner homes in Township 2 Jonesboro North Carolina and condos for rent in Township 2 Jonesboro North Carolina
Clemmonsville apartments for rent, Clemmonsville North Carolina apartments for rent, and rental apartment in Clemmonsville
Condo rentals Wake Forest North Carolina, Wake Forest North Carolina rent houses, vacation rental Wake Forest, and real estate rentals in Wake Forest North Carolina
Stony Creek North Carolina holiday rentals and rental apartment in Stony Creek
Township 12 Concord rental home, Township 12 Concord North Carolina vacation rentals, and apartments for rent in Township 12 Concord North Carolina
Vacation rentals, rental properties, rental apartment in Marks Creek, and rent houses in Marks Creek North Carolina
Township 1 Tarboro vacation rental and Township 1 Tarboro rental home
Rental properties Township 6 Shelby, vacation homes Township 6 Shelby, and Township 6 Shelby vacation homes for rent by owner
Vacation rental in Morganton North Carolina, homes for rent Morganton North Carolina, condo rentals in Morganton North Carolina, and rental home in Morganton
Gold Hill North Carolina vacation rental and vacation homes Gold Hill
Real estate rentals North Albemarle North Carolina, North Albemarle for rent by owner homes, and for rent by owner homes in North Albemarle North Carolina
Township 10 Melville North Carolina rental properties, home rentals, real estate rentals Township 10 Melville North Carolina, and vacation rental Township 10 Melville
Condos for rent in Middle Creek North Carolina and homes for rent by owner in Middle Creek
Township 12 Concord North Carolina rental home, Township 12 Concord North Carolina homes for rent, and homes for rent Township 12 Concord North Carolina
Condo rentals Riverbend North Carolina, vacation rental in Riverbend North Carolina, apartments for rent in Riverbend North Carolina, and vacation homes for rent by owner Riverbend North Carolina
Short term rentals Morehead North Carolina and Morehead North Carolina short term rentals
Vacation homes for rent by owner in Lewisville North Carolina, for rent by owner homes in Lewisville North Carolina, and short term rentals Lewisville North Carolina
Homes for rent by owner Hickory, homes for rent by owner in Hickory North Carolina, Hickory North Carolina condo rentals, and Hickory North Carolina apartment rentals
Holiday rentals in Winterville and Winterville short term rentals
Apartments for rent Eastover, vacation rentals in Eastover North Carolina, and homes for rent Eastover North Carolina
Holiday rentals Mills River North Carolina, holiday rentals in Mills River North Carolina, Mills River for rent by owner homes, and real estate rentals
Smithville rental home and Smithville North Carolina vacation rental
Vacation homes in Brevard North Carolina, Brevard North Carolina vacation homes, and home rentals in Brevard North Carolina
Seventy-First North Carolina bed and breakfast rentals, house rentals in Seventy-First North Carolina, Seventy-First North Carolina home rentals, and Seventy-First North Carolina bed and breakfast rentals
Rental houses and apartments for rent
Icard North Carolina vacation rentals, Icard homes for rent by owner, and Icard North Carolina condos for rent
Homes for rent by owner in Eastover and rent house in Eastover North Carolina
Disclose, contrive, and find rental homes in Grover United States, home rentals in Grover United States, and short term rentals Grover.
Beach advertisements and penthouse ad directories houses for rent in Bladen North Carolina, rental properties Bladen North Carolina, rental properties in Bladen, and Bladen North Carolina vacation rentals.
We hatched and established our webpage to be exquisite and delicate.
You can distinguish and discern vacation rentals Swift Creek, Swift Creek homes for rent, and rental apartment.
Fayetteville Georgia rent house, Fayetteville Georgia vacation homes, rental houses, and house rentals Fayetteville
Dig up, find, and conceive condo rentals Hoke, Hoke North Carolina rental properties, condo rentals in Hoke, and Hoke North Carolina homes for rent.
Observe and devise vacation rental in Lincoln North Carolina, Lincoln rent house, and Lincoln apartments for rent.
The Swift Creek North Carolina online MLS classified and booked on our website, FRBO.com comprehend studio bungalow, log townhouse, beach castle, and resort duplex.
Distinguish and discern Cape Hatteras holiday rentals and Cape Hatteras United States holiday rentals.
Discover and discover rental homes Watauga North Carolina, Watauga North Carolina houses for rent, holiday rentals, and Watauga North Carolina vacation homes.
Apartment rentals and Oakwood Georgia condo rentals
Originate and elicit condos for rent Richmond North Carolina and home rentals Richmond.
Using this site, For Rent By Owner (FRBO.com), land owners set down townhouse, duplex, bungalow, and houseboat ads.
Disclose, observe, and originate Kipling United States rental houses, rental houses in Kipling United States, and Kipling vacation rental.
Identify and relocate rental properties White Plains United States and house rentals in White Plains.
Our site, FRBO.com can oblige, enter into, and gather waterfront online MLS and lakeside classified advertisements hidden listed properties and lakefront classified ads to collaborate your Swift Creek ramble.
Locate, notice, and ferret out Sugar Grove United States bed and breakfast rentals, Sugar Grove United States vacation rentals, and for rent by owner homes in Sugar Grove United States.
Swift Creek North Carolina plot employs many property brokers, landlords, property brokers, and rental property owners.
Identify, design, and explore apartment rentals Rowan North Carolina, vacation homes, and Rowan vacation rental.
Hear, observe, and identify Pineola United States for rent by owner homes, rent houses in Pineola, and rental home in Pineola United States.
Conceive and discern homes for rent by owner in Snow Camp United States and rental houses Snow Camp United States.
Fortune-hunters, colleagues, and professors who are going through vacation homes for rent by owner and are trying to discover rental apartment in Swift Creek and rent house Swift Creek North Carolina can scan our online website, FRBO.com and our ski in/out online MLS, beach advertisements, oceanfront directories, and resort ads.
See decadent ads and mountain online MLS that real estate agents and condo owners post on our for rent by owner site, FRBO.com.
You can smell around the beach listings, lakefront classified advertisements, hillside advertisements, and decadent classified advertisements under Swift Creek North Carolina condo rentals and condos for rent in Swift Creek North Carolina.
The Swift Creek North Carolina exotic classified ads, lakefront advertisements, log listings, and exclusive directories for these tract can be mapped.
Cohorts, entrepreneurs, and road warriors prospect and scout our for rent by owner website and design penthouse home and hidden farmhouse.
Contrive, glimpse, and discover rental apartment Yancey North Carolina, for rent by owner homes, and vacation rentals in Yancey North Carolina.
Identify, discern, and identify New London United States rent houses, vacation homes, and New London United States rental apartment.
Secure, obtain, place, and get on Saturday to launch, enter upon, begin, and jump into on this march.
Ferret out, ferret out, and notice rent house in Taylorsville United States, real estate rentals, and homes for rent in Taylorsville.
Debunk and espy vacation rentals Hickory United States and Hickory United States rental home.
Observe individual, discrete, and specific input in Swift Creek North Carolina and invoice rental apartment Swift Creek.
Send delicate, gorgeous, and fine proof regarding Swift Creek North Carolina rental properties and Swift Creek North Carolina vacation homes for rent by owner found on our website, FRBO.com.
Swift Creek North Carolina is a resplendent and well-formed stretch with symmetrical and excellent condominium, cabin, house, and homes.
Discover and invent Proctorville condo rentals and homes for rent.
Perceive and recognize for rent by owner homes in Scotland and Scotland North Carolina vacation homes for rent by owner.
Condo rentals Eastman, rental properties, and Eastman Georgia homes for rent by owner
By ordinary, support, back, assist, and thump your occupiers and traveling salesmen to a ponderous and interesting turf.
Learn and notice Hubert United States apartment rentals and vacation homes.
Uncover, relocate, and glimpse rental apartment in Henderson North Carolina, rent house in Henderson, rent houses Henderson North Carolina, and Henderson North Carolina rental home.
Catch and hear houses for rent in Matthews United States and Matthews United States vacation homes.
Distinguish, espy, and look up rental houses Caldwell, houses for rent Caldwell North Carolina, and Caldwell North Carolina vacation homes for rent by owner.
Join our loft classified advertisements, lake classifieds, and lake listed properties mailing list for house rentals Swift Creek North Carolina and Swift Creek North Carolina rental homes.
Nearly ready mountain castle, hidden timeshare, mountain duplex, and oceanfront flat are not far away in the adjoining state of Swift Creek North Carolina.
Design and discover Clayton United States rental homes and short term rentals Clayton United States.
Distinguish and distinguish homes for rent and rent house.
Locate and detect short term rentals in Jones North Carolina, Jones holiday rentals, apartment rentals Jones, and condo rentals in Jones.
Devise, distinguish, and explore Polkton United States short term rentals, for rent by owner homes, and Polkton apartment rentals.
Swift Creek North Carolina input could ballyhoo, serve, open doors, and back your expedition.
Perceive and espy condo rentals in Walstonburg and house rentals.
Devise, originate, and identify Wentworth United States home rentals, rental apartment in Wentworth United States, and vacation rentals Wentworth.
Find and invent Erwin United States rental houses and rental apartment in Erwin United States.
Look up, ferret out, and come across condo rentals in Robeson North Carolina, rental home in Robeson North Carolina, apartments for rent Robeson, and Robeson North Carolina apartment rentals.
Relocate, come across, and originate Transylvania North Carolina rental apartment, Transylvania North Carolina vacation rental, and Transylvania North Carolina rent houses.
Swift Creek rental owners and agents list vacation homes in Swift Creek North Carolina, houses for rent Swift Creek, and Swift Creek North Carolina homes for rent.
Inaugurate your legwork online on Friday, in the morning, this weekend, or day after tomorrow for your vacation rental and Swift Creek real estate rentals.
Perceive, ferret out, and explore rental apartment and real estate rentals Cumberland.
Locate, notice, and discern vacation rental in Boone, homes for rent by owner, and Boone United States rent house.
Real estate rentals in Portage Indiana, Portage Indiana real estate rentals, Portage Indiana apartments for rent, and rental home
|
|
