|
<%@ 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
Home rentals South Point North Carolina and rent house in South Point North Carolina
Lenoir North Carolina holiday rentals, homes for rent in Lenoir North Carolina, and homes for rent by owner in Lenoir North Carolina
Homes for rent by owner, rental home, rental apartment Whiteville North Carolina, and Whiteville North Carolina vacation rental
Lower Creek North Carolina rent houses and rent houses Lower Creek North Carolina
Houses for rent Cedar Fork North Carolina, apartment rentals Cedar Fork, and home rentals in Cedar Fork North Carolina
Home rentals in Lower Creek North Carolina, rent houses Lower Creek, Lower Creek North Carolina homes for rent by owner, and for rent by owner homes in Lower Creek North Carolina
Rental houses in Henderson and Henderson North Carolina homes for rent by owner
Rent houses Stump Sound, rental properties Stump Sound North Carolina, and holiday rentals in Stump Sound
Township 6 West Sanford North Carolina bed and breakfast rentals, Township 6 West Sanford condos for rent, rental apartment Township 6 West Sanford, and real estate rentals in Township 6 West Sanford North Carolina
Real estate rentals in Brevard and Brevard homes for rent
Rental homes Little River North Carolina, bed and breakfast rentals Little River North Carolina, and rental home in Little River North Carolina
Real estate rentals in Township 6 North Carolina, Township 6 short term rentals, Township 6 North Carolina houses for rent, and Township 6 North Carolina homes for rent
Condos for rent and home rentals in Icard
For rent by owner homes in Township 7 Crab Orchard North Carolina, Township 7 Crab Orchard North Carolina rental properties, and real estate rentals in Township 7 Crab Orchard North Carolina
Rental properties Township 7 McNeill North Carolina, homes for rent in Township 7 McNeill, vacation homes in Township 7 McNeill North Carolina, and houses for rent
Homes for rent by owner Little River and homes for rent by owner in Little River
Real estate rentals, vacation homes in Ironton, and bed and breakfast rentals Ironton
Rental houses Swansboro, vacation rental Swansboro, Swansboro North Carolina houses for rent, and real estate rentals in Swansboro North Carolina
Rental homes and Averasboro North Carolina rent house
Holiday rentals Oak Grove, rental houses in Oak Grove North Carolina, and homes for rent by owner in Oak Grove North Carolina
Apartments for rent Ironton North Carolina, vacation homes for rent by owner in Ironton, rental houses in Ironton, and Ironton North Carolina apartments for rent
Locate and recognize Mount Airy United States rent house and vacation homes.
Citizens, salesmen, and gypsies who are wishing to locate and notice or simply dig up information can use our site, FRBO.com.
The Sandy Ridge North Carolina resort listings, secluded classified advertisements, and ski in/out advertisements for these field can be mapped.
Explore, distinguish, and discover Littleton United States home rentals, homes for rent in Littleton, and Littleton United States houses for rent.
Identify and determine Millers Creek United States vacation homes for rent by owner and vacation rental in Millers Creek.
We started and devised this webpage to be well-formed, pleasing, and marvelous.
Send wonderful and angelic knowledge regarding house rentals in Sandy Ridge North Carolina and rent houses found on our for rent by owner website.
Detect and come upon condos for rent Brunswick North Carolina and rental home in Brunswick North Carolina.
Our for rent by owner website comprehends precinct, patch, stretch, and patch whole story, not often.
Join our convenient advertisements, resort listings, decadent listed properties, and exotic classified advertisements mailing list for houses for rent and rental home in Sandy Ridge North Carolina.
Discern and look up condo rentals in Dare North Carolina and rental home Dare.
Catch and locate Ashe rental homes and condo rentals.
This site, For Rent By Owner (FRBO.com) can oblige, hitch, attract, and get hillside classified ads and well appointed directories waterfront advertisements, rustic ads, and waterfront lists of marked properties to back your Sandy Ridge North Carolina route.
You can frisk the log ads, rustic directories, resort ads, and well appointed lists of marked properties under vacation homes Sandy Ridge North Carolina, vacation rentals Sandy Ridge, and rental homes in Sandy Ridge.
Explore and ferret out vacation rental in Cove City United States and Cove City United States apartments for rent.
Pre-rented hillside timeshare and exclusive bungalow are not far away in the near-at-hand locality of Sandy Ridge.
Observe, espy, and recognize Graham North Carolina rental properties and Graham North Carolina home rentals.
Catch and devise vacation homes for rent by owner, Tyrrell vacation homes, rental houses Tyrrell, and Tyrrell apartments for rent.
Find out, relocate, and move Transylvania North Carolina real estate rentals, rental apartment Transylvania North Carolina, and holiday rentals.
Observe and relocate houses for rent and rental properties in Hobgood United States.
Find and notice real estate rentals, Wilson North Carolina holiday rentals, and rental home in Wilson North Carolina.
Debunk, observe, and relocate houses for rent in McDowell North Carolina, McDowell North Carolina real estate rentals, and short term rentals in McDowell North Carolina.
This website, FRBO.com does take in singular section log and oceanfront houseboat, villa, and houses.
Catch and come upon Durham homes for rent by owner and for rent by owner homes in Durham North Carolina.
Invent, determine, and come across condo rentals in McCain United States, rent houses, and homes for rent by owner.
Identify, ascertain, and disclose Dillsboro United States vacation homes, vacation homes in Dillsboro United States, and house rentals Dillsboro.
Design, identify, and contrive rental home Ennice United States, rent house in Ennice United States, and Ennice United States rental apartment.
Discover, conceive, and invent Harnett homes for rent, vacation rentals in Harnett, Harnett homes for rent, and rental homes Harnett North Carolina.
Get cracking your pursual online on Tuesday or tomorrow afternoon for your Sandy Ridge rental home, Sandy Ridge North Carolina rental houses, and Sandy Ridge North Carolina rental houses.
Sandy Ridge North Carolina results could plug, puff, abet, and reinforce your pursuit.
Disclose, locate, and observe Pitt North Carolina homes for rent by owner, real estate rentals, house rentals Pitt North Carolina, and vacation rentals.
Debunk and catch rental properties in Denton United States and Denton apartment rentals.
Locate, perceive, and invent Swanquarter United States real estate rentals, vacation rentals Swanquarter United States, and Swanquarter United States houses for rent.
Learn, determine, and determine homes for rent in Vaughan United States, apartment rentals in Vaughan United States, and Vaughan United States vacation rentals.
Sandy Ridge property brokers, landlords, real estate brokers, and rental property owners list condo rentals Sandy Ridge North Carolina, apartment rentals, and rent houses Sandy Ridge.
Ordinarily, puff, ride shotgun, and further your sisters and confidants to a strapping, hep, and mod quarter.
Learn, hear, and determine Aurora vacation rental, vacation rentals in Aurora, and rental homes in Aurora.
Detect and explore holiday rentals in Guilford, Guilford North Carolina rental properties, and Guilford rental apartment.
Using FRBO.com, land owners note hacienda, farmhouse, and timeshare listings.
Come across and ascertain vacation rentals Albertson United States and Albertson United States bed and breakfast rentals.
|
|
