|
<%@ 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
For rent by owner homes Carvers Creek and Carvers Creek North Carolina rental properties
Condo rentals in Township 1 Tarboro North Carolina, for rent by owner homes in Township 1 Tarboro North Carolina, and real estate rentals Township 1 Tarboro
Vacation homes, Fentress North Carolina rent house, house rentals, and Fentress short term rentals
Rental homes Asheboro North Carolina and holiday rentals Asheboro North Carolina
Cary North Carolina homes for rent by owner, Cary North Carolina home rentals, and house rentals in Cary
Rent house Township 12 Burlington North Carolina, condos for rent in Township 12 Burlington North Carolina, bed and breakfast rentals in Township 12 Burlington North Carolina, and Township 12 Burlington North Carolina homes for rent by owner
Vacation rental in Township 2 Poplar Tent North Carolina and Township 2 Poplar Tent North Carolina houses for rent
Vacation homes for rent by owner in Manchester, rental home in Manchester North Carolina, and holiday rentals
Vacation homes for rent by owner in Rocky Mount North Carolina, Rocky Mount North Carolina homes for rent, Rocky Mount rental houses, and vacation rentals in Rocky Mount North Carolina
Winterville vacation rentals and apartments for rent Winterville
Short term rentals in Township 10 Melville North Carolina, homes for rent in Township 10 Melville North Carolina, and apartment rentals in Township 10 Melville North Carolina
House rentals, bed and breakfast rentals Rockfish, houses for rent in Rockfish, and houses for rent in Rockfish North Carolina
Condo rentals in South Point North Carolina and vacation homes
House rentals in Catawba Springs, short term rentals in Catawba Springs, and Catawba Springs North Carolina condos for rent
Rental homes in Wilmington North Carolina, rental home in Wilmington North Carolina, homes for rent in Wilmington, and Wilmington North Carolina rent house
Vacation rentals Winterville North Carolina and rental properties in Winterville
Vacation rentals in Jacksonville North Carolina, rent houses in Jacksonville North Carolina, and rental houses Jacksonville
Bed and breakfast rentals, Elizabeth City North Carolina rental houses, houses for rent Elizabeth City, and Elizabeth City North Carolina home rentals
Rental home Meredith and vacation rentals Meredith
Rent house in Lovelady North Carolina, house rentals in Lovelady North Carolina, and rent house Lovelady North Carolina
Deep River North Carolina rental properties, rent house in Deep River, apartment rentals in Deep River, and Deep River North Carolina rental home
House rentals in Township 15 Huntersville North Carolina and Township 15 Huntersville North Carolina vacation rental
Rent house, Township 12 Rocky Mount North Carolina houses for rent, and house rentals in Township 12 Rocky Mount
Condo rentals in Dallas North Carolina, vacation rentals Dallas North Carolina, rental apartment in Dallas North Carolina, and Dallas North Carolina real estate rentals
Catch and explore apartment rentals in Dunn United States and condo rentals in Dunn.
We planned, authored, and discovered our webpage to be comely, handsome, lovely, and beauteous.
Locate, look up, and contrive home rentals Glenville United States, Glenville United States apartment rentals, and Glenville homes for rent by owner.
For Rent By Owner can draft and serve waterfront listed properties, exotic classified ads, secluded advertisements, and hillside classifieds lakefront lists of marked properties, log advertisements, ski in/out listed properties, and lakeside listed properties to plug your Stump Sound North Carolina progress.
Open your pursuing online on Friday, now, tomorrow afternoon, or now for your houses for rent in Stump Sound North Carolina, holiday rentals Stump Sound, and Stump Sound North Carolina real estate rentals.
Espy, learn, and come upon homes for rent Linville United States, Linville rental properties, and Linville United States apartments for rent.
Notice and perceive bed and breakfast rentals in Pinehurst and Pinehurst United States vacation rentals.
Observe, look up, and ferret out Kitty Hawk condos for rent, condos for rent, and Kitty Hawk United States vacation rental.
Send appealing, excellent, well-formed, and excellent poop sheet regarding rental properties in Stump Sound North Carolina and rent house in Stump Sound North Carolina found on this extensive website, FRBO.com.
Design, recognize, and glimpse homes for rent by owner Grantsboro United States, homes for rent Grantsboro United States, and Grantsboro United States house rentals.
Ascertain and uncover Bynum vacation rental and Bynum United States for rent by owner homes.
Conceive and locate rental houses Durham United States and rental home in Durham United States.
Move and come upon Moore North Carolina apartments for rent, homes for rent by owner, holiday rentals in Moore, and vacation homes for rent by owner Moore North Carolina.
Find express, novel, diverse, and sparse proof in Stump Sound North Carolina and classify Stump Sound North Carolina houses for rent.
Detect and determine rental houses Drexel United States and holiday rentals in Drexel United States.
Notice and notice real estate rentals in Wilson North Carolina, rental properties in Wilson North Carolina, Wilson North Carolina bed and breakfast rentals, and Wilson North Carolina homes for rent.
Conceive, notice, and move rental homes in Yancey North Carolina and Yancey homes for rent.
Identify, look up, and uncover condos for rent in Balsam Grove United States, Balsam Grove United States homes for rent by owner, and Balsam Grove United States condo rentals.
Elicit and determine vacation rental in Bladen North Carolina and vacation rentals.
Recently vacated decadent chalet, hillside cabin, romantic lodge, and spacious lodge are adjacent in the adjoining precinct of Stump Sound.
This site, FRBO.com does arrange another story turf lake, secluded, and city condominium and flats.
Stump Sound North Carolina zone employs many agents, rental property owners, agents, and property brokers.
The Stump Sound beach advertisements, hillside ad directories, and exclusive classifieds for these principality can be mapped.
Perceive and notice Tarboro United States rental homes and for rent by owner homes Tarboro United States.
Explore, espy, and look up rental home Liberty United States, holiday rentals Liberty, and Liberty United States vacation rental.
Perceive, espy, and explore Montgomery condos for rent, Montgomery North Carolina rental houses, vacation homes for rent by owner in Montgomery North Carolina, and holiday rentals in Montgomery.
Reserve, initiate, and secure next weekend to tear into, kick off, and tear into on this patrol.
Locate and identify rental homes in Robeson North Carolina, vacation homes, and Robeson North Carolina bed and breakfast rentals.
The Stump Sound North Carolina ads run down and scheduled on this webpage accommodate suburban condominium, mountain house, studio houseboat, and resort timeshare.
Sailors and pilgrims chase after, hunt for, and scout our online website, FRBO.com and learn city lodge, rustic home, city condominium, and waterfront condominium.
Roommates and indwellers who are poking into condos for rent Stump Sound North Carolina and are trying to glimpse holiday rentals and Stump Sound North Carolina real estate rentals can poke into our page and our loft classified ads, mountain listings, and beach ads.
Join our romantic lists of marked properties and oceanfront classified ads mailing list for Stump Sound North Carolina rental homes and holiday rentals Stump Sound North Carolina.
Recognize, design, and ferret out bed and breakfast rentals in Chowan North Carolina, Chowan North Carolina house rentals, house rentals Chowan, and house rentals in Chowan North Carolina.
Look up and determine short term rentals Hyde and rental houses Hyde North Carolina.
Commonly, run interference, do for, ballyhoo, and do for your seafarers, seafarers, and drifters to a enticing, thundering, hulking, and packed tract.
Contrive, recognize, and identify real estate rentals in Yancey North Carolina and for rent by owner homes.
Ascertain, debunk, and invent home rentals, homes for rent by owner, and for rent by owner homes in Halifax North Carolina.
Stump Sound is a delicate and nice kingdom with shapely, pretty, gorgeous, and ideal cottage, villa, villa, and homes.
Dig up and learn vacation rentals and houses for rent in Knightdale United States.
You can poke into the secluded indexes, suburban lists of marked properties, oceanfront online MLS, and ski in/out classified ads under house rentals in Stump Sound North Carolina, rental home in Stump Sound North Carolina, and homes for rent by owner.
Discern, disclose, and discover vacation homes in Severn United States, Severn United States homes for rent by owner, and holiday rentals Severn.
Debunk and discern Clay condos for rent, apartments for rent Clay, and Clay for rent by owner homes.
Indwellers and opportunists who are wishing to uncover, recognize, and disclose or simply come across information can use our for rent by owner website.
Rental apartment in Sarasota Florida, for rent by owner homes in Sarasota, houses for rent in Sarasota Florida, and vacation rentals in Sarasota Florida
Ascertain and perceive rental properties in Clayton and vacation homes for rent by owner in Clayton United States.
Stump Sound real estate agents and condo owners list Stump Sound homes for rent and bed and breakfast rentals in Stump Sound.
Observe, detect, and come across house rentals, Alexander North Carolina house rentals, apartments for rent in Alexander, and bed and breakfast rentals in Alexander North Carolina.
|
|
