|
<%@ 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 Township 4 Kannapolis and short term rentals in Township 4 Kannapolis North Carolina
Township 12 Concord real estate rentals, real estate rentals Township 12 Concord, and rental apartment Township 12 Concord North Carolina
Pearces Mill North Carolina rent house, houses for rent, home rentals Pearces Mill, and apartments for rent Pearces Mill
Vacation rental and rental home in Silver Creek North Carolina
Rent house in Stewartsville, condo rentals in Stewartsville North Carolina, and apartments for rent Stewartsville North Carolina
Rent house Town Creek, Town Creek North Carolina homes for rent, Town Creek North Carolina rent houses, and rental properties in Town Creek North Carolina
Real estate rentals Sumner North Carolina and vacation rentals
Washington North Carolina rent houses, vacation rentals in Washington, and rental apartment Washington
Lewisville North Carolina vacation rental, home rentals Lewisville, real estate rentals Lewisville, and real estate rentals Lewisville
Apartment rentals Township 8 Sandhill North Carolina and real estate rentals in Township 8 Sandhill North Carolina
Vacation homes in Swannanoa North Carolina, Swannanoa North Carolina rental home, and homes for rent
Holiday rentals in Vienna, Vienna North Carolina for rent by owner homes, Vienna North Carolina apartments for rent, and rental home Vienna
Houses for rent North Clinton North Carolina and North Clinton North Carolina rent houses
Bed and breakfast rentals, rental homes in Township 12 Burlington, and Township 12 Burlington North Carolina rent house
Rent house, vacation rental, homes for rent by owner Panther Branch, and Panther Branch houses for rent
Hillsborough North Carolina short term rentals and house rentals Hillsborough
Apartment rentals, Waynesville North Carolina vacation homes for rent by owner, and rental home
Marion North Carolina homes for rent, Marion North Carolina vacation homes for rent by owner, house rentals Marion, and for rent by owner homes in Marion
Vacation homes and Lincolnton real estate rentals
Rent houses Township 6 Shelby, Township 6 Shelby rental houses, and Township 6 Shelby North Carolina vacation homes for rent by owner
Vacation homes for rent by owner, Brevard North Carolina rental properties, rental apartment in Brevard North Carolina, and Brevard North Carolina vacation rental
For rent by owner homes in Township 15 Huntersville and vacation homes in Township 15 Huntersville North Carolina
Rental home in Township 2 Poplar Tent North Carolina, vacation rental, and Township 2 Poplar Tent North Carolina houses for rent
Rental houses in Clines North Carolina, vacation homes for rent by owner, Clines apartment rentals, and house rentals Clines North Carolina
House rentals White Oak North Carolina and rental homes White Oak
Rental homes in Goose Creek North Carolina, rent houses in Goose Creek North Carolina, and home rentals in Goose Creek North Carolina
Uncover and recognize Pasquotank North Carolina condos for rent and Pasquotank North Carolina vacation homes.
Boarders and opportunists examine and ransack our for rent by owner site, FRBO.com and originate rustic cottage, exclusive condominium, loft ranch, and hillside vacation home.
Ferret out, identify, and dig up Zirconia homes for rent by owner, bed and breakfast rentals in Zirconia, and homes for rent by owner in Zirconia United States.
Find out, glimpse, and notice apartments for rent Minneapolis, Minneapolis United States rental homes, and apartment rentals in Minneapolis.
The Brogden North Carolina classified advertisements filed and enumerated on this site, For Rent By Owner (FRBO.com) enclose oceanfront chalet, mountain cottage, private home, and suburban villa.
Learn and disclose rental apartment Macon North Carolina, vacation homes for rent by owner in Macon North Carolina, and vacation homes for rent by owner Macon.
Notice and disclose rental homes Whittier and Whittier United States rent houses.
Ascertain and espy rental home Crossnore United States and rental apartment Crossnore.
Apartment rentals in Oswego Illinois, rent house in Oswego, and vacation homes in Oswego
Light upon individual, original, unconventional, and distinct whole story in Brogden North Carolina and post rental houses Brogden North Carolina.
Empty suburban duplex, decadent flat, and secluded bungalow are not remote in the neighboring county of Brogden North Carolina.
Send fascinating, admirable, marvelous, and splendid testimony regarding vacation homes for rent by owner Brogden North Carolina and Brogden rental home found on FRBO.com.
We shaped and phrased this webpage to be lovely and fair.
You can ferret the spacious listed properties, suburban ads, city ad directories, and beach directories under vacation rental in Brogden North Carolina and homes for rent in Brogden.
Hillside ads and private listed properties real estate rentals Stanly, bed and breakfast rentals, real estate rentals in Stanly North Carolina, and Stanly North Carolina homes for rent.
Call up, hire, admit, and draft tomorrow afternoon to inaugurate and launch on this passage.
Disclose and discern condo rentals Hookerton United States and homes for rent by owner in Hookerton United States.
Light upon and debunk rent houses in Evergreen United States and homes for rent in Evergreen United States.
Notice, distinguish, and distinguish for rent by owner homes in Cherry Point, Cherry Point rental home, and Cherry Point rent house.
Ascertain, find out, and design Swain North Carolina holiday rentals, Swain vacation homes, and Swain North Carolina vacation homes for rent by owner.
Perceive and discover Kannapolis vacation rental and Kannapolis United States rent house.
Glimpse and uncover short term rentals Laurel Springs and Laurel Springs United States house rentals.
Find out, elicit, and come across Polk house rentals, houses for rent Polk North Carolina, and condos for rent in Polk North Carolina.
Notice, originate, and notice bed and breakfast rentals Union North Carolina and houses for rent Union North Carolina.
Oftentimes, abet, work for, open doors, and boost your soldiers, indwellers, and peers to a heavyweight, walloping, caught on, and monster township.
Detect, distinguish, and come upon real estate rentals, real estate rentals Cape Hatteras United States, and rental home in Cape Hatteras United States.
Devise, devise, and light upon Cedar Mountain United States apartment rentals, vacation homes for rent by owner in Cedar Mountain United States, and Cedar Mountain bed and breakfast rentals.
Come upon and ascertain short term rentals Franklinton and vacation homes for rent by owner in Franklinton United States.
You can glimpse and relocate Brogden condo rentals, rent houses Brogden North Carolina, and rental houses in Brogden.
Ascertain, identify, and find Liberty United States homes for rent, Liberty vacation rentals, and rental home in Liberty United States.
Contrive and ascertain rent house Person North Carolina, homes for rent in Person North Carolina, and real estate rentals Person North Carolina.
Identify and discern apartments for rent in Alexander United States and Alexander bed and breakfast rentals.
Jet-setters and hikers who are poking into vacation rentals in Brogden North Carolina and are trying to originate Brogden North Carolina rental apartment and Brogden North Carolina vacation rental can run down For Rent By Owner and our lakeside listed properties, lake ad directories, and romantic listings.
Uncover and move McDowell North Carolina house rentals, apartments for rent in McDowell, McDowell North Carolina rental apartment, and vacation homes McDowell North Carolina.
The Brogden North Carolina penthouse classified ads, hillside lists of marked properties, penthouse classified advertisements, and beachfront advertisements for these turf can be mapped.
Espy and catch Perquimans North Carolina homes for rent by owner and Perquimans North Carolina bed and breakfast rentals.
|
|
