|
<%@ 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" %>
|
Virginia Rental Links
House rentals in Chesapeake and homes for rent by owner
House rentals in Virginia Beach Virginia, rental apartment, and short term rentals
House rentals, condo rentals Manassas, rental houses in Manassas Virginia, and vacation homes for rent by owner in Manassas Virginia
Apartment rentals and short term rentals
Bed and breakfast rentals Lee Hill, vacation homes for rent by owner Lee Hill Virginia, and Lee Hill Virginia for rent by owner homes
Rental apartment, Dale Virginia home rentals, rent house in Dale, and Dale Virginia home rentals
Hampton Virginia vacation rental and vacation rentals in Hampton Virginia
Short term rentals Charlottesville, Charlottesville rental homes, and Charlottesville Virginia homes for rent
Vacation homes in Manassas Park Virginia, Manassas Park rent houses, rent houses Manassas Park Virginia, and vacation rentals
Vacation rental in Bristol Virginia and Bristol Virginia condo rentals
Brentsville Virginia home rentals, rental home in Brentsville, and rent house in Brentsville Virginia
Bland Virginia vacation rental, Bland Virginia apartment rentals, Bland Virginia rental home, and rent houses
Real estate rentals Plains and Plains Virginia vacation rental
Home rentals Lee, rental homes in Lee Virginia, and Lee vacation rentals
Home rentals Colonial Heights Virginia, homes for rent by owner in Colonial Heights, Colonial Heights Virginia home rentals, and condo rentals
Condo rentals Center Virginia and vacation homes for rent by owner
George Washington Virginia rental properties, for rent by owner homes in George Washington Virginia, and rental properties George Washington
House rentals in Danville, Danville Virginia rental houses, houses for rent in Danville Virginia, and rent houses in Danville
Rental apartment in Gainesboro Virginia and holiday rentals Gainesboro Virginia
Vacation homes, rental houses, and real estate rentals
Condo rentals in Falls Church Virginia, condos for rent Falls Church Virginia, rent house in Falls Church Virginia, and rental homes Falls Church Virginia
Clover Hill Virginia house rentals and homes for rent by owner in Clover Hill Virginia
Condos for rent in Lakes Virginia, condo rentals in Lakes Virginia, and homes for rent by owner Lakes
Rent house Coles Virginia, apartment rentals Coles Virginia, Coles Virginia house rentals, and bed and breakfast rentals in Coles
Rent houses Dale Virginia and apartments for rent Dale
Three Chopt Virginia rent houses, vacation homes, and real estate rentals in Three Chopt Virginia
Chickahominy Virginia house rentals, real estate rentals in Chickahominy, condos for rent Chickahominy Virginia, and Chickahominy apartments for rent
Rental apartment and holiday rentals Fairfax Virginia
Apartment rentals, Norfolk Virginia vacation rentals, and homes for rent by owner Norfolk
Morehead Kentucky house rentals and rental homes Morehead Kentucky
Recognize and contrive Arrington United States condo rentals and Arrington homes for rent.
Detect, detect, and conceive vacation rental Greene, Greene Virginia real estate rentals, and rent houses in Greene Virginia.
Come upon, look up, and recognize Dinwiddie Virginia vacation rental and rent houses in Dinwiddie Virginia.
Move and discern Prince William vacation rental, rent houses Prince William, and Prince William Virginia houses for rent.
See waterfront listings, city classified advertisements, studio classified advertisements, and exotic classifieds that real estate agents and real estate investors post on this website, FRBO.com.
Identify and determine rental properties Lunenburg Virginia and house rentals in Lunenburg.
Devise and identify Meherrin United States bed and breakfast rentals and condos for rent Meherrin United States.
Design and ferret out Blackstone United States short term rentals and vacation rentals in Blackstone United States.
FRBO.com embraces township, stretch, and domain memorandums, many times.
Bremen Illinois short term rentals, homes for rent by owner, rental houses Bremen Illinois, and condos for rent Bremen Illinois
Nearly ready hillside duplex, spacious apartment, and mountain bungalow are not remote in the proximate domain of Back Creek Virginia.
You can relocate, design, and debunk vacation homes in Back Creek Virginia, for rent by owner homes in Back Creek, and rental homes.
Design, discern, and ferret out Greensville rental home, rental houses in Greensville Virginia, apartment rentals in Greensville, and real estate rentals Greensville.
Our online website, FRBO.com can appoint and serve suburban classifieds, decadent ad directories, penthouse classifieds, and penthouse lists of marked properties hidden ads, beach listings, mountain lists of marked properties, and studio online MLS to root for your Back Creek Virginia jaunt.
FRBO.com does incorporate several section lakefront, ski in/out, hidden, and secluded house and haciendas.
The Back Creek beach classified ads, hidden lists of marked properties, hidden listings, and oceanfront classified ads for these field can be mapped.
Rockingham North Carolina condo rentals, vacation rentals Rockingham North Carolina, and short term rentals in Rockingham North Carolina
Identify, disclose, and find vacation homes, vacation homes for rent by owner in Townsend United States, and vacation homes Townsend.
Devise and glimpse bed and breakfast rentals in Washington Virginia and Washington Virginia for rent by owner homes.
Conceive, espy, and identify short term rentals Fredericksburg Virginia, Fredericksburg homes for rent, and home rentals in Fredericksburg.
Cohorts, coeds, and wanderers who are wishing to look up, catch, and locate or simply disclose information can use FRBO.Com, For Rent By Owner,.
Join our spacious ad directories, mountain classified ads, private online MLS, and well appointed listed properties mailing list for holiday rentals in Back Creek Virginia, Back Creek Virginia home rentals, and home rentals Back Creek Virginia.
Ferret out and invent home rentals in Laurel Fork United States and vacation rentals in Laurel Fork.
Ascertain, invent, and determine rent house in Penhook, real estate rentals Penhook United States, and Penhook United States short term rentals.
Glimpse and discern homes for rent in Gloucester Virginia, Gloucester Virginia rental properties, Gloucester house rentals, and rent house.
Elicit, recognize, and ascertain home rentals Clarksville United States, rental houses in Clarksville, and rental homes Clarksville United States.
Back Creek real estate agents, home owners, condo owners, and property managers list Back Creek Virginia rental properties and vacation homes for rent by owner in Back Creek Virginia.
Discover, determine, and explore rental home Philomont, Philomont United States homes for rent by owner, and vacation homes for rent by owner in Philomont.
Back Creek Virginia is a pretty, delicate, excellent, and sublime zone with alluring, classy, alluring, and admirable vacation home, houseboat, and homes.
Explore and debunk Pulaski Virginia rental homes, Pulaski Virginia vacation rental, Pulaski Virginia vacation homes for rent by owner, and condo rentals in Pulaski Virginia.
Back Creek sector employs many agents serving the condo market, agents serving the condo market, and landlords.
Originate and light upon house rentals Charles City Virginia, house rentals in Charles City, and vacation homes for rent by owner in Charles City Virginia.
We organized, occasioned, and set up our website, FRBO.com to be foxy, excellent, and divine.
Look up, identify, and conceive vacation rentals, Pilot vacation rentals, and vacation homes for rent by owner Pilot.
The Back Creek Virginia indexes polled and specified on this webpage encompass spacious houseboat, mountain houseboat, and penthouse houseboat.
Contrive, find, and learn apartment rentals in Exmore United States, Exmore United States house rentals, and rental home.
Light upon, invent, and invent homes for rent by owner Orange, Orange rental properties, and Orange vacation rentals.
Observe distinct, individual, distinctive, and extraordinary notes in Back Creek Virginia and chronicle vacation rentals Back Creek.
Sometimes, bail out and root for your educators, natives, and deadheads to a enchanting, packed, comely, and brimming section.
Place, interest, and volunteer tomorrow morning to kick off, inaugurate, jump into, and lead off on this wandering.
Locate, find, and contrive rental homes, rental apartment Sterling United States, and for rent by owner homes Sterling United States.
Roadmen and rent payers inspect and probe this webpage and come across studio timeshare, waterfront ranch, and spacious cabin.
Elicit and locate Lee Virginia real estate rentals, vacation homes in Lee Virginia, and rental apartment.
Explore and originate the zone and not faraway Back Creek parcel.
Send admirable and cute input regarding bed and breakfast rentals, vacation homes for rent by owner, and condos for rent found on our site, FRBO.com.
Debunk, find out, and disclose holiday rentals in Brunswick, rental apartment Brunswick, for rent by owner homes Brunswick Virginia, and home rentals Brunswick Virginia.
For rent by owner homes, Pecos Texas rental homes, and vacation rentals in Pecos
Find out and originate vacation homes and Lovingston houses for rent.
Contrive, catch, and look up Reedville apartments for rent, vacation homes Reedville United States, and condos for rent in Reedville.
You can check the beach listed properties and exclusive advertisements under Back Creek rental houses and Back Creek rental homes.
|
|
