|
<%@ 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
Marion North Carolina bed and breakfast rentals and rental home in Marion
Vacation rental Jacksonville, real estate rentals Jacksonville, and homes for rent by owner in Jacksonville North Carolina
Lockwoods Folly North Carolina rent houses, Lockwoods Folly North Carolina apartment rentals, bed and breakfast rentals in Lockwoods Folly, and Lockwoods Folly North Carolina home rentals
Apartment rentals Leicester and bed and breakfast rentals Leicester North Carolina
South Point North Carolina homes for rent, rental homes, and short term rentals in South Point
For rent by owner homes Waynesville, houses for rent, Waynesville apartments for rent, and bed and breakfast rentals Waynesville North Carolina
Rental home in McLauchlin North Carolina and vacation homes McLauchlin North Carolina
Rent houses in Atwell, homes for rent Atwell, and short term rentals in Atwell North Carolina
Houses for rent Monroe North Carolina, homes for rent, Monroe North Carolina houses for rent, and Monroe rental homes
Vacation homes Topsail and vacation rental in Topsail North Carolina
Vacation homes for rent by owner in Locke North Carolina, homes for rent by owner in Locke North Carolina, and real estate rentals in Locke
Rent house in Elizabeth City North Carolina, for rent by owner homes in Elizabeth City North Carolina, Elizabeth City North Carolina vacation homes, and houses for rent in Elizabeth City North Carolina
Rental houses and Bartons Creek North Carolina homes for rent by owner
Gastonia North Carolina real estate rentals, condo rentals in Gastonia North Carolina, and condo rentals
Condo rentals in Thomasville North Carolina, Thomasville North Carolina condo rentals, Thomasville home rentals, and vacation rentals in Thomasville North Carolina
Swansboro North Carolina real estate rentals and Swansboro North Carolina condos for rent
Vacation homes for rent by owner Limestone North Carolina, Limestone North Carolina vacation rentals, and for rent by owner homes in Limestone
Rental homes, rental apartment in Township 5 Providence, vacation homes for rent by owner in Township 5 Providence North Carolina, and home rentals
Lexington vacation rentals and vacation homes
Rent house in Township 4 Kings Mountain North Carolina, Township 4 Kings Mountain North Carolina vacation homes, and home rentals Township 4 Kings Mountain North Carolina
Homes for rent by owner, vacation rental in Township 6 Clear Creek North Carolina, home rentals in Township 6 Clear Creek North Carolina, and homes for rent by owner Township 6 Clear Creek North Carolina
Homes for rent by owner in Newton and homes for rent by owner in Newton
Hillsborough rental homes, short term rentals in Hillsborough North Carolina, and rent houses
Gold Hill North Carolina condo rentals, condos for rent in Gold Hill, Gold Hill North Carolina holiday rentals, and apartment rentals in Gold Hill
Lovelady North Carolina vacation homes for rent by owner and Lovelady North Carolina vacation homes for rent by owner
Franklin North Carolina real estate rentals, rent house in Franklin, and houses for rent Franklin
Homes for rent by owner in Meredith North Carolina, vacation rentals in Meredith, Meredith North Carolina homes for rent by owner, and apartment rentals
Apartment rentals in Henderson and vacation homes in Henderson North Carolina
Real estate rentals, rental properties Swift Creek North Carolina, and Swift Creek North Carolina real estate rentals
Waynesville North Carolina vacation homes for rent by owner, vacation homes Waynesville North Carolina, houses for rent in Waynesville North Carolina, and rental properties in Waynesville North Carolina
House rentals in Cedar Fork North Carolina and homes for rent Cedar Fork North Carolina
Recognize and glimpse Brunswick United States vacation homes for rent by owner and for rent by owner homes in Brunswick United States.
Determine and find homes for rent in Guilford North Carolina, Guilford North Carolina bed and breakfast rentals, and vacation homes in Guilford North Carolina.
Debunk, catch, and disclose Columbus rental properties, holiday rentals Columbus, and homes for rent in Columbus North Carolina.
Design, find, and move bed and breakfast rentals, for rent by owner homes in Bullock United States, and Bullock rental apartment.
Move, invent, and find out Montreat rental homes, apartment rentals Montreat, and Montreat United States condos for rent.
This webpage does accommodate particular quarter ski in/out, mountain, lakeside, and beach houseboat, farmhouse, and farmhouses.
Perceive and observe Johnston North Carolina holiday rentals, bed and breakfast rentals in Johnston, Johnston North Carolina rent houses, and Johnston North Carolina vacation homes for rent by owner.
Rental properties in Rochester Hills and vacation homes Rochester Hills
Trinity property agents, property owners, and property agents list Trinity apartment rentals and holiday rentals Trinity.
FRBO.Com, For Rent By Owner, can hitch and interest decadent directories, resort listed properties, rustic listings, and decadent online MLS penthouse indexes, private indexes, and lake ads to push your Trinity tramp.
Disclose and glimpse houses for rent Rosman and Rosman United States rental home.
Relocate and move Pembroke rent house and bed and breakfast rentals in Pembroke.
Dig up and espy homes for rent by owner and real estate rentals Smyrna.
We instituted, made, and imagined FRBO.Com, For Rent By Owner, to be appealing, radiant, charming, and ideal.
Real estate rentals, Leyden Illinois vacation rental, rent house, and Leyden Illinois vacation rentals
Launch your expedition online next week or in the morning for your rent house in Trinity North Carolina and vacation homes in Trinity North Carolina.
Find and detect Granville North Carolina condos for rent, Granville North Carolina apartment rentals, and short term rentals Granville.
Find out, discover, and ferret out rent house Gates North Carolina, Gates North Carolina vacation homes for rent by owner, condos for rent in Gates North Carolina, and vacation rentals in Gates North Carolina.
Discern, disclose, and elicit Polk North Carolina vacation homes for rent by owner and Polk condos for rent.
Vacation homes for rent by owner in Cortez Colorado and homes for rent in Cortez
Come across, look up, and uncover rental home Warrenton United States, rental properties, and Warrenton United States house rentals.
Distinguish, contrive, and disclose rent house in Chowan, Chowan condos for rent, rental properties, and homes for rent Chowan.
Using this extensive website, FRBO.com, real estate brokers enumerate hacienda and villa ad directories.
Educators, roamers, and teachers study, go through, and scout For Rent By Owner and look up beachfront home, lakeside timeshare, and resort lodge.
Identify and devise rental houses in Ashe and apartment rentals in Ashe North Carolina.
Center Indiana rental properties and Center Indiana homes for rent by owner
Every once in a while, work with, thump, and sustain your indwellers and explorers to a liked and prominent section.
Espy, distinguish, and explore rental home in Mountain Home United States, homes for rent Mountain Home United States, and Mountain Home United States rental apartment.
Elicit and come across vacation homes Ridgeway and Ridgeway United States condos for rent.
Notice, recognize, and hear rental apartment in Crumpler United States, rental homes in Crumpler United States, and rental houses in Crumpler United States.
Take on, embody, draft, and draft on Friday to initiate, get cracking, jump into, and get going on this travel.
Identify, design, and catch short term rentals Waxhaw, houses for rent Waxhaw United States, and homes for rent by owner Waxhaw United States.
Uncover and observe rental homes in Orange North Carolina and short term rentals in Orange North Carolina.
Rental apartment in Sedalia Missouri, vacation homes, Sedalia Missouri apartment rentals, and bed and breakfast rentals Sedalia Missouri
Ferret out, recognize, and discover homes for rent Pitt and for rent by owner homes.
Exclusive directories and rustic ad directories Henderson North Carolina apartments for rent, Henderson condos for rent, Henderson houses for rent, and rental properties in Henderson North Carolina.
Light upon and hear house rentals and condo rentals in Cedar Falls United States.
Detect and devise rental apartment Hyde North Carolina and Hyde North Carolina rental home.
Rent house, apartments for rent Burley, and homes for rent by owner in Burley Idaho
Trinity North Carolina is a admirable, pleasing, handsome, and ideal state with admirable, pleasing, excellent, and handsome lodge, townhouse, duplex, and chalets.
Originate, observe, and devise vacation rental in Eagle Springs United States, Eagle Springs United States house rentals, and rent house Eagle Springs United States.
Come upon and ascertain short term rentals in Ocracoke United States and real estate rentals.
Disclose and observe real estate rentals in Granville North Carolina and Granville North Carolina rental properties.
Catch, discern, and originate Edgecombe rental homes and homes for rent Edgecombe North Carolina.
Move, identify, and uncover rent house Ash United States, Ash condo rentals, and rental houses.
Come upon and ferret out Ridgecrest United States rental apartment and house rentals in Ridgecrest United States.
Perceive, find, and catch rental apartment, rental houses in Anson North Carolina, and Anson North Carolina for rent by owner homes.
Come across and debunk Pittsboro United States vacation homes and vacation rentals in Pittsboro.
Send fascinating, stunning, and foxy conclusions regarding vacation homes for rent by owner Trinity North Carolina and houses for rent in Trinity North Carolina found on FRBO.com.
See exclusive ad directories, oceanfront classified ads, beachfront ads, and beach listings that property managers and property brokers post on For Rent By Owner.
Ascertain, learn, and ferret out Stokes North Carolina house rentals, Stokes vacation homes for rent by owner, and holiday rentals Stokes.
Locate, explore, and detect rent houses Stokes, Stokes rental homes, homes for rent in Stokes North Carolina, and rental homes.
Explore and disclose Halifax rental homes, Halifax rental properties, and houses for rent.
Detect and disclose Coats United States rent house and apartment rentals in Coats United States.
Learn and uncover Polk North Carolina home rentals, condos for rent in Polk, Polk North Carolina house rentals, and rental apartment.
Come across, identify, and disclose rent houses in Vale United States, condo rentals Vale, and Vale condo rentals.
Discern, invent, and distinguish rental homes Wayne, home rentals Wayne North Carolina, and Wayne North Carolina vacation rentals.
Hear and catch Prospect Hill apartments for rent and Prospect Hill United States homes for rent.
Dig up, catch, and relocate house rentals Marston United States, for rent by owner homes, and Marston United States house rentals.
Trinity North Carolina picture could work with, work with, thump, and aid your inquest.
Tenants and traveling sales representatives who are wishing to conceive, debunk, and observe or simply discern information can use FRBO.Com, For Rent By Owner,.
Identify and explore rental properties and for rent by owner homes in Hot Springs United States.
This webpage involves locality and square figures, intermittently.
You can look up and observe Trinity North Carolina condo rentals and vacation rentals Trinity.
The Trinity North Carolina lists of marked properties tabbed and inscribed on our page seat city castle, beach townhouse, beach chalet, and secluded houseboat.
Comrades and co-workers who are scouring bed and breakfast rentals Trinity North Carolina and are trying to catch Trinity North Carolina vacation rental and homes for rent by owner in Trinity North Carolina can beat about FRBO.Com, For Rent By Owner, and our penthouse online MLS, lake online MLS, loft ad directories, and spacious online MLS.
|
|
