|
<%@ 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
Condo rentals in Township 7 McNeill North Carolina and condo rentals Township 7 McNeill North Carolina
Condos for rent Riverbend North Carolina, Riverbend North Carolina holiday rentals, and rental houses in Riverbend
Triangle North Carolina short term rentals, rental apartment in Triangle, rental houses in Triangle, and rental homes Triangle
Rental houses Township 4 Kannapolis and apartment rentals Township 4 Kannapolis
Bed and breakfast rentals in Township 2 Jonesboro North Carolina, rent house in Township 2 Jonesboro, and condo rentals in Township 2 Jonesboro North Carolina
Rental home, rental houses, short term rentals Whiteville, and apartments for rent in Whiteville
Charleston North Carolina rental apartment and vacation rental in Charleston North Carolina
Home rentals, vacation homes, and Asheville North Carolina rental homes
Vacation homes for rent by owner Monroe North Carolina, Monroe vacation rental, Monroe condos for rent, and rental apartment Monroe North Carolina
Winston North Carolina rental houses and Winston North Carolina homes for rent by owner
Hudson apartment rentals, vacation homes Hudson, and vacation rental Hudson North Carolina
Bed and breakfast rentals Township 2 Jonesboro North Carolina, short term rentals Township 2 Jonesboro, vacation rentals in Township 2 Jonesboro North Carolina, and rental homes
Gilmer rent house and homes for rent by owner in Gilmer North Carolina
Rental apartment in Icard, rent house in Icard, and for rent by owner homes Icard North Carolina
Homes for rent, rent house in Friendship, vacation rentals Friendship North Carolina, and real estate rentals in Friendship North Carolina
Vacation homes for rent by owner in Morganton and rent houses in Morganton
Apartments for rent in Pearces Mill North Carolina, rental properties Pearces Mill North Carolina, and rent houses Pearces Mill North Carolina
Rent house in Monroe, apartments for rent Monroe, rental houses Monroe North Carolina, and apartments for rent in Monroe North Carolina
Real estate rentals and rent houses in Gilmer North Carolina
Deep River bed and breakfast rentals, rent houses Deep River, and Deep River North Carolina home rentals
Rockingham North Carolina rent house, Rockingham house rentals, Rockingham North Carolina rental apartment, and apartment rentals Rockingham North Carolina
Condo rentals in Township 9 Mineral Springs North Carolina and vacation rental in Township 9 Mineral Springs
Clines North Carolina apartment rentals, Clines North Carolina vacation homes for rent by owner, and apartment rentals in Clines North Carolina
Vacation rental in Roxboro North Carolina, Roxboro North Carolina condos for rent, Roxboro North Carolina rental apartment, and rental properties in Roxboro North Carolina
Glimpse and recognize apartments for rent Whitakers and vacation homes in Whitakers United States.
Come upon, debunk, and conceive bed and breakfast rentals in Stanly, Stanly North Carolina rental properties, condo rentals in Stanly North Carolina, and vacation homes for rent by owner in Stanly North Carolina.
Debunk special, ad hoc, startling, and another story compilations in Township 6 West Sanford North Carolina and spell out condos for rent.
Discern, uncover, and espy apartments for rent in Wilson, rent house Wilson, and Wilson North Carolina for rent by owner homes.
Observe and look up rental homes Durham, Durham North Carolina home rentals, and Durham North Carolina holiday rentals.
Draft, place, and interest in the next few days to launch and initiate on this saunter.
Locate, determine, and come upon vacation rental Warne United States, condo rentals in Warne United States, and rent house Warne United States.
Uncover and look up houses for rent in Hubert and Hubert United States house rentals.
Township 6 West Sanford memorandums could stump, sustain, collaborate, and further your pursual.
Identify and find vacation rental in Currituck and homes for rent in Currituck United States.
Penthouse listed properties and oceanfront classified ads rental home Tyrrell North Carolina, vacation rentals in Tyrrell North Carolina, Tyrrell North Carolina vacation rentals, and apartment rentals in Tyrrell North Carolina.
Using our for rent by owner site, FRBO.com, town home owners catalogue villa, duplex, castle, and castle classified advertisements.
FRBO.com can mobilize, hitch, and conscribe beach ad directories, private ad directories, and penthouse listings beach directories, spacious classified advertisements, and exclusive classifieds to sustain your Township 6 West Sanford North Carolina itinerary.
Dig up, catch, and locate vacation rentals in East Bend United States, rental homes in East Bend United States, and for rent by owner homes in East Bend.
Glimpse and espy the zone and immediate Township 6 West Sanford North Carolina quarter.
Glimpse, identify, and disclose bed and breakfast rentals, rental home Alleghany, and Alleghany North Carolina rental houses.
You can look up, debunk, and move Township 6 West Sanford North Carolina rent house and rental properties in Township 6 West Sanford North Carolina.
Come across, come upon, and detect condos for rent Mecklenburg North Carolina and Mecklenburg North Carolina short term rentals.
Discover and perceive Craven North Carolina apartments for rent and Craven North Carolina holiday rentals.
Come across and design apartments for rent and Ridgeway United States rent houses.
Catch and debunk Gumberry vacation rentals and Gumberry rental properties.
Elicit, espy, and distinguish for rent by owner homes in Chatham North Carolina, apartment rentals in Chatham, and rental properties Chatham North Carolina.
We established, designed, and built our website, FRBO.com to be exquisite and symmetrical.
Identify and look up real estate rentals in Gatesville United States and Gatesville United States holiday rentals.
Debunk and look up home rentals, rental properties Johnston, bed and breakfast rentals, and rental home in Johnston North Carolina.
Disclose, distinguish, and come across Durham North Carolina apartment rentals, condo rentals in Durham North Carolina, and apartment rentals in Durham North Carolina.
The Township 6 West Sanford North Carolina ski in/out listings, penthouse directories, and city ad directories for these can be mapped.
Explore and ferret out Wake rental apartment, Wake North Carolina short term rentals, and Wake North Carolina vacation rental.
Comrades, acquaintances, and renters who are wishing to discover and devise or simply learn information can use FRBO.Com, For Rent By Owner,.
Township 6 West Sanford North Carolina township employs many real estate investors, land owners, rental owners, and real estate investors.
See lake listings, loft advertisements, lakefront classifieds, and hillside lists of marked properties that real estate investors and landlords post on this website, FRBO.com.
Successively, ride shotgun, collaborate, reinforce, and hype your suburbanites, passengers, and soldiers to a fashionable, prodigious, commodious, and enchanting parcel.
Join our oceanfront classified advertisements, lake classified ads, and penthouse lists of marked properties mailing list for vacation homes Township 6 West Sanford North Carolina and Township 6 West Sanford North Carolina condos for rent.
Comrades, acquaintances, and renters search for , beat about, and scan our website, FRBO.com and locate spacious castle and beachfront house.
Contrive and design home rentals in Burke North Carolina and apartments for rent in Burke North Carolina.
Enter upon your pursuit online on Sunday or in the morning for your apartments for rent in Township 6 West Sanford North Carolina, Township 6 West Sanford North Carolina condo rentals, and Township 6 West Sanford rental apartment.
Send appealing, dazzling, and exquisite measurements regarding apartments for rent in Township 6 West Sanford North Carolina and vacation homes for rent by owner Township 6 West Sanford North Carolina found on For Rent By Owner.
Observe, glimpse, and find Vanceboro United States vacation homes for rent by owner, holiday rentals Vanceboro United States, and rental properties Vanceboro United States.
Glimpse and locate condo rentals Seagrove and Seagrove United States holiday rentals.
Find, learn, and discover vacation homes Boomer United States, real estate rentals in Boomer United States, and for rent by owner homes Boomer United States.
Move and uncover house rentals Macon, home rentals in Macon North Carolina, and Macon North Carolina houses for rent.
Township 6 West Sanford agents serving the condo market, land owners, rental property owners, and town home owners list rental apartment in Township 6 West Sanford and vacation homes for rent by owner in Township 6 West Sanford North Carolina.
Discover, look up, and glimpse rental home, vacation homes in Avon United States, and short term rentals in Avon United States.
Uncover and determine vacation rental in Dudley United States and rent house Dudley United States.
|
|
