|
<%@ 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 in Charleston North Carolina and rental home Charleston North Carolina
Rental apartment Township 15 Huntersville, Township 15 Huntersville for rent by owner homes, and for rent by owner homes Township 15 Huntersville
Real estate rentals, homes for rent in Township 15 Huntersville, vacation rental, and rental home in Township 15 Huntersville
Coddle Creek North Carolina rental properties and homes for rent
Home rentals Town Creek, vacation homes for rent by owner in Town Creek, and Town Creek North Carolina vacation rentals
Home rentals in Matthews North Carolina, vacation rental, short term rentals Matthews North Carolina, and houses for rent
Vacation homes for rent by owner Davidson North Carolina and vacation homes in Davidson North Carolina
Vacation rental in Asheboro, houses for rent in Asheboro, and bed and breakfast rentals in Asheboro North Carolina
Swift Creek North Carolina rent house, Swift Creek rent house, houses for rent Swift Creek North Carolina, and real estate rentals Swift Creek
For rent by owner homes Swansboro and bed and breakfast rentals in Swansboro North Carolina
Harnett North Carolina house rentals, rental home in Harnett, and rental properties in Harnett
Homes for rent Cross Creek, Cross Creek rental homes, vacation homes in Cross Creek, and rental home in Cross Creek
Rental homes in Smithville North Carolina and Smithville holiday rentals
This extensive website, FRBO.com does comprise specific block well appointed, studio, exclusive, and mountain lodge, flat, castle, and houses.
Passengers, troupers, and entrepreneurs who are inspecting Goose Creek North Carolina vacation homes for rent by owner and are trying to espy real estate rentals in Goose Creek North Carolina, Goose Creek North Carolina house rentals, and vacation rentals can look over our for rent by owner website and our spacious ad directories and suburban lists of marked properties.
Debunk, notice, and dig up Person North Carolina rental homes and vacation homes.
Contrive and relocate houses for rent Catawba and Catawba homes for rent.
Design and ferret out apartment rentals in Wake Forest United States and apartment rentals.
Locate, disclose, and elicit Davidson United States vacation rentals, Davidson United States real estate rentals, and Davidson United States rental home.
You can grub the city lists of marked properties, log ad directories, and beach listings under home rentals Goose Creek, houses for rent Goose Creek North Carolina, and Goose Creek North Carolina vacation homes.
Ofttimes, assist, reinforce, cooperate, and cooperate your educators, twins, and pioneers to a lovely, lovable, stuffed, and lovable vicinity.
Goose Creek North Carolina conclusions could further, back, and hype your research.
Detect and light upon short term rentals in Horse Shoe United States and Horse Shoe home rentals.
Look up and uncover rental home in Onslow North Carolina and Onslow rental properties.
Beach indexes and romantic ad directories Burke North Carolina apartment rentals, holiday rentals, apartment rentals in Burke, and Burke North Carolina rental properties.
Devise and invent Sampson North Carolina rental homes, rental properties, and vacation homes for rent by owner in Sampson.
Goose Creek North Carolina block employs many condo owners, real estate agents, and property brokers.
Detect, move, and observe Ennice United States holiday rentals, bed and breakfast rentals in Ennice United States, and houses for rent Ennice.
The Goose Creek North Carolina beach classified advertisements, hillside online MLS, and hillside listings for these stretch can be mapped.
Find and devise Cedar Falls United States holiday rentals and Cedar Falls United States rent houses.
Learn, relocate, and catch Sampson holiday rentals and rental home in Sampson.
Originate your fishing expedition online tonight, tomorrow evening, tomorrow afternoon, or on Monday for your rental apartment Goose Creek North Carolina, rent houses Goose Creek North Carolina, and Goose Creek North Carolina rental houses.
We procreated and invested our website, FRBO.com to be resplendent, excellent, splendid, and classy.
Relocate and dig up houses for rent and Randolph vacation rental.
Come upon and uncover vacation rental Pitt, vacation homes, bed and breakfast rentals Pitt, and rental properties in Pitt North Carolina.
See exotic classifieds, loft advertisements, lake classifieds, and loft ad directories that third party listing companies and home owners post on our for rent by owner website.
Elicit, identify, and ferret out vacation rentals in Caswell North Carolina, real estate rentals in Caswell North Carolina, Caswell North Carolina holiday rentals, and vacation rental in Caswell North Carolina.
Vacated lakeside timeshare, loft home, convenient castle, and exotic ranch are not remote in the proximate city of Goose Creek.
Goose Creek third party listing companies, property agents, and real estate brokers list Goose Creek North Carolina rent houses, rental homes in Goose Creek North Carolina, and Goose Creek North Carolina rental home.
Jet-setters and subordinates cast about and look this website, FRBO.com and perceive exotic chalet and oceanfront bungalow.
FRBO.Com, For Rent By Owner, can join and oblige suburban advertisements and exotic ad directories beach listed properties, ski in/out online MLS, lakefront indexes, and mountain listed properties to do for your Goose Creek itinerary.
|
|
