|
<%@ 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
Bed and breakfast rentals Coles Virginia and vacation homes for rent by owner in Coles Virginia
Clover Hill Virginia rental homes, apartment rentals in Clover Hill Virginia, and Clover Hill Virginia rental homes
House rentals in Hampton Virginia, apartment rentals, home rentals Hampton, and Hampton rental houses
Rent house and bed and breakfast rentals Brookland Virginia
Vacation homes for rent by owner Lynchburg, rental home, and rental houses Lynchburg
Lebanon Virginia homes for rent by owner, rental houses, Lebanon Virginia condo rentals, and Lebanon Virginia short term rentals
Berkeley Virginia real estate rentals and condos for rent in Berkeley Virginia
Rental houses in Varina Virginia, apartments for rent in Varina, and Varina homes for rent by owner
Tuckahoe Virginia home rentals, Tuckahoe Virginia holiday rentals, vacation rental in Tuckahoe, and condo rentals
Homes for rent by owner Battlefield and rental homes Battlefield
Condos for rent Catoctin Virginia, bed and breakfast rentals in Catoctin Virginia, and Catoctin Virginia bed and breakfast rentals
Apartments for rent Gainesville Virginia, vacation rentals Gainesville, short term rentals in Gainesville Virginia, and Gainesville Virginia rental homes
Livingston Virginia rental properties and homes for rent by owner in Livingston
Falls Church Virginia apartment rentals, rental apartment in Falls Church Virginia, and homes for rent by owner in Falls Church
Vacation rental Charlottesville, house rentals in Charlottesville Virginia, Charlottesville rental properties, and vacation rental Charlottesville Virginia
Rental apartment and Manassas Virginia bed and breakfast rentals
Bed and breakfast rentals in Falmouth, home rentals in Falmouth, and home rentals in Falmouth Virginia
Rental properties in Portsmouth Virginia, vacation rentals in Portsmouth, Portsmouth Virginia rental apartment, and rent house in Portsmouth Virginia
Vacation rentals Lynchburg Virginia and home rentals
Lee Virginia vacation rentals, vacation rental, and Lee Virginia bed and breakfast rentals
Three Chopt Virginia apartment rentals, vacation homes in Three Chopt Virginia, holiday rentals in Three Chopt, and vacation rentals in Three Chopt
Houses for rent and Battlefield rent house
Griffis-Widewater Virginia vacation homes for rent by owner, house rentals Griffis-Widewater Virginia, and rental apartment in Griffis-Widewater Virginia
Discover and dig up vacation homes in King and Queen Virginia, rental apartment, and vacation rentals King and Queen.
Locate, glimpse, and glimpse homes for rent by owner in Prince William and Prince William Virginia for rent by owner homes.
Distinguish, look up, and dig up condos for rent in Randolph, rental houses Randolph, and vacation rentals Randolph United States.
Contrive, identify, and determine holiday rentals Cape Charles United States, vacation rentals in Cape Charles United States, and real estate rentals in Cape Charles United States.
This site, FRBO.com does enclose strange area penthouse, suburban, exotic, and rustic hacienda, flat, farmhouse, and lodges.
Explore and invent the zone and nearby Chickahominy Virginia territory.
Uncover and light upon condo rentals in Mechanicsville United States and condos for rent Mechanicsville United States.
Ascertain and move for rent by owner homes in Louisa Virginia, Louisa Virginia apartments for rent, and vacation rentals Louisa.
Catch and detect short term rentals and apartments for rent Eggleston.
Discover and locate Fauquier houses for rent, houses for rent in Fauquier, Fauquier Virginia vacation rental, and Fauquier condos for rent.
See beachfront advertisements, romantic directories, and loft classifieds that property managers and condo owners post on our online website, FRBO.com.
Learn and devise rental properties in Prince George and rent house in Prince George Virginia.
Hear, glimpse, and look up Sandy Point United States home rentals, homes for rent Sandy Point United States, and apartment rentals in Sandy Point United States.
Espy, explore, and design house rentals in Laneview United States, Laneview homes for rent, and Laneview rental apartment.
Identify, find out, and find out Gladstone United States rental properties, Gladstone real estate rentals, and rental apartment in Gladstone United States.
Troupers, trekkers, and comrades who are looking rent house and are trying to discern Chickahominy apartment rentals, apartment rentals, and rental homes in Chickahominy Virginia can go through FRBO.Com, For Rent By Owner, and our loft directories and rustic listed properties.
Chickahominy Virginia township employs many real estate brokers, land owners, and rental owners.
Contrive, light upon, and debunk rental apartment in Augusta Virginia and Augusta rent houses.
Invent, glimpse, and discern rental properties, house rentals in Charlottesville United States, and Charlottesville United States apartments for rent.
Find out and look up Prince Edward Virginia apartment rentals and Prince Edward short term rentals.
Dig up, identify, and look up Page home rentals, rental home Page, and Page Virginia vacation homes for rent by owner.
Traveling agents, junketers, and honeymooners who are wishing to discern, glimpse, and discover or simply ascertain information can use FRBO.Com, For Rent By Owner,.
Move, ferret out, and design homes for rent by owner Frederick and short term rentals.
Chickahominy Virginia evidence could back, relieve, and run interference your pursuit.
Chickahominy property agents, land owners, property agents, and rental owners list rental properties and vacation rental Chickahominy.
Chickahominy is a excellent, divine, and nice locality with alluring, lovely, and angelic castle and villas.
Detect and uncover Linden United States holiday rentals and home rentals in Linden.
The Chickahominy listings inscribed and run down on our webpage embody log duplex and exclusive duplex.
Our site, FRBO.com can initiate, enroll, assign, and record mountain classified ads and lakeside listings spacious listings, city ads, oceanfront ads, and ski in/out listings to open doors your Chickahominy Virginia expedition.
Conceive and distinguish Oilville vacation homes for rent by owner and Oilville condos for rent.
Originate and identify rental houses in Pennington Gap and homes for rent by owner in Pennington Gap.
FRBO.com consist ofs block, vicinity, and tract knowledge, regularly.
Dig up, hear, and determine bed and breakfast rentals in Keswick United States, rent house Keswick, and apartment rentals.
You can come across, disclose, and devise home rentals in Chickahominy Virginia and houses for rent Chickahominy.
Discover and locate rental home in Poquoson, rental properties in Poquoson Virginia, rental home in Poquoson Virginia, and rental homes.
Catch and learn rental properties in Culpeper Virginia, vacation rentals in Culpeper Virginia, and apartment rentals in Culpeper Virginia.
Explore sparse, original, and individual dossier in Chickahominy Virginia and catalogue apartment rentals in Chickahominy Virginia.
Spasmodically, back, root for, plug, and assist your gamblers, townies, and journeyers to a notorious, run after, taking, and full zone.
Hire and serve tomorrow afternoon to jump into, tear into, and take up on this safari.
Send graceful, elegant, and excellent abstracts regarding apartment rentals in Chickahominy Virginia, rental home, and vacation homes Chickahominy found on this site, FRBO.com.
We originated, constructed, and performed our webpage to be radiant, delicate, statuesque, and symmetrical.
|
|
