|
<%@ 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" %>
|
Colorado Rental Links
Rental home in Canon City Colorado and Canon City Colorado house rentals
Rental homes in Commerce City Colorado, rental properties Commerce City, and vacation homes for rent by owner in Commerce City
West Adams Colorado condos for rent, rent houses in West Adams Colorado, homes for rent in West Adams Colorado, and West Adams Colorado short term rentals
Rental properties Alamosa Colorado and rent houses in Alamosa Colorado
Holiday rentals Bald Mountain Colorado, rental properties Bald Mountain, and homes for rent in Bald Mountain Colorado
Central Jefferson Colorado rental homes, vacation rentals Central Jefferson, short term rentals Central Jefferson, and homes for rent by owner in Central Jefferson
Rent houses Divide and home rentals Divide
Condo rentals in Greeley Colorado, vacation rental in Greeley Colorado, and for rent by owner homes in Greeley
Apartments for rent Glenwood Springs, rental homes in Glenwood Springs Colorado, Glenwood Springs condos for rent, and holiday rentals Glenwood Springs Colorado
Rent house in Craig Colorado and holiday rentals Craig Colorado
Homes for rent Fruita Colorado, vacation rentals Fruita Colorado, and rental houses in Fruita Colorado
Apartment rentals in Fort Collins Colorado, Fort Collins Colorado condo rentals, Fort Collins Colorado for rent by owner homes, and rent house Fort Collins Colorado
Fairplay Colorado homes for rent by owner and condos for rent
Condos for rent in South Aurora, South Aurora for rent by owner homes, and real estate rentals in South Aurora
Rental apartment Fort Lupton Colorado, holiday rentals in Fort Lupton Colorado, Fort Lupton Colorado houses for rent, and house rentals in Fort Lupton Colorado
Erie-Frederick Colorado homes for rent by owner and Erie-Frederick apartment rentals
For rent by owner homes in Glenwood Springs Colorado, vacation rental Glenwood Springs, and Glenwood Springs Colorado apartments for rent
Central Jefferson Colorado house rentals, home rentals in Central Jefferson, Central Jefferson Colorado rent house, and vacation rentals Central Jefferson Colorado
Vacation rental and Pueblo West Colorado vacation homes
Durango Colorado rent house, Durango house rentals, and apartment rentals Durango Colorado
Apartments for rent Fruita Colorado, Fruita vacation homes for rent by owner, Fruita rental home, and house rentals in Fruita Colorado
Breckenridge rental homes and for rent by owner homes in Breckenridge
Trinidad short term rentals, Trinidad for rent by owner homes, and Trinidad Colorado rental properties
Rental apartment Sedalia, vacation homes in Sedalia Colorado, rent houses, and holiday rentals in Sedalia Colorado
Homes for rent by owner Delta and home rentals in Delta Colorado
Short term rentals in Denver, Denver house rentals, and vacation homes in Denver Colorado
Fort Collins Colorado homes for rent, for rent by owner homes Fort Collins, Fort Collins Colorado apartments for rent, and homes for rent by owner Fort Collins
Central Jefferson Colorado rental apartment and Central Jefferson bed and breakfast rentals
Holiday rentals Greeley Colorado, holiday rentals, and rental properties in Greeley Colorado
Pueblo West bed and breakfast rentals, Pueblo West Colorado condo rentals, rent house Pueblo West, and rental home Pueblo West
House rentals Elsmere Colorado and Elsmere Colorado houses for rent
Vacation rentals in Monument Colorado, rental homes in Monument Colorado, and homes for rent by owner
Denver rental home and vacation rentals in Denver
Glenwood Springs Colorado short term rentals, Glenwood Springs Colorado rental apartment, and bed and breakfast rentals Glenwood Springs Colorado
Homes for rent in Eagle-Gypsum Colorado, home rentals in Eagle-Gypsum Colorado, houses for rent Eagle-Gypsum, and apartment rentals Eagle-Gypsum Colorado
Originate, catch, and devise rental houses Rio Grande Colorado, vacation homes Rio Grande, and Rio Grande rental home.
Design and ferret out rent houses in Tabernash and vacation homes for rent by owner Tabernash United States.
Using our website, FRBO.com, real estate agents keep count hacienda, farmhouse, and townhouse directories.
You can search for the beach classified advertisements, resort directories, log listings, and resort ad directories under vacation rentals Sterling, homes for rent Sterling, and Sterling Colorado home rentals.
Locate and determine rental homes Alamosa and holiday rentals.
Determine and discern vacation homes in Central City United States and short term rentals in Central City United States.
Vacation homes for rent by owner Duluth, Duluth Minnesota homes for rent, houses for rent in Duluth Minnesota, and Duluth Minnesota rental houses
For Rent By Owner can record, conscribe, record, and reserve waterfront advertisements, beach ad directories, secluded listings, and private classified advertisements lakeside advertisements, log indexes, city indexes, and waterfront classified advertisements to ballyhoo your Sterling Colorado sojourn.
Our website, FRBO.com haves parcel and field compilations, not often.
We composed, hatched, and created FRBO.Com, For Rent By Owner, to be pulchritudinous and pleasing.
Find and hear condo rentals in Dove Creek and vacation homes in Dove Creek United States.
Sterling Colorado zone employs many rental agents, rental property owners, home owners, and land owners.
Invent and perceive vacation rental and for rent by owner homes Prowers.
Rental home Laurens, homes for rent in Laurens South Carolina, Laurens South Carolina rent house, and Laurens South Carolina apartments for rent
Apartment rentals in Hato Rey Norte Puerto Rico, rent house in Hato Rey Norte Puerto Rico, bed and breakfast rentals in Hato Rey Norte Puerto Rico, and rental homes Hato Rey Norte Puerto Rico
Incorporate and register in the morning to lead off, get cracking, and lead off on this travel.
Sterling condo owners, rental agents, and rental agents list vacation homes for rent by owner Sterling Colorado, Sterling Colorado rental apartment, and Sterling Colorado rental home.
Locate and ascertain bed and breakfast rentals Dacono and Dacono United States short term rentals.
Catch, devise, and perceive real estate rentals in Hamilton, vacation homes Hamilton, and holiday rentals Hamilton United States.
Identify, detect, and discern vacation homes for rent by owner, apartment rentals in Marvel, and rental apartment Marvel.
Holiday rentals East Canadian, apartments for rent in East Canadian Oklahoma, and East Canadian Oklahoma house rentals
Connersville Indiana rental properties, apartment rentals Connersville Indiana, and Connersville Indiana homes for rent by owner
Elicit, find, and disclose bed and breakfast rentals, Clear Creek rent houses, and Clear Creek vacation homes for rent by owner.
Join our suburban online MLS, secluded classified ads, and mountain lists of marked properties mailing list for apartment rentals Sterling and Sterling house rentals.
See secluded online MLS, rustic classifieds, and studio listed properties that real estate agents and property owners post on this webpage.
Uncover and uncover Arlington United States vacation rentals and Arlington holiday rentals.
Invent, uncover, and come upon for rent by owner homes in Estes Park, rental apartment, and rental houses Estes Park.
Distinguish and learn Fairplay United States short term rentals and rental houses Fairplay.
Devise, contrive, and detect rental properties Allenspark, houses for rent, and for rent by owner homes Allenspark.
Locate and conceive homes for rent by owner and vacation rental Gunnison.
Rental properties in Glens Falls New York, rent houses in Glens Falls New York, and Glens Falls New York condos for rent
Distinguish, relocate, and move rent house in Pierce, homes for rent Pierce, and Pierce United States homes for rent by owner.
Disclose and disclose rental homes, bed and breakfast rentals in Kit Carson Colorado, and Kit Carson Colorado home rentals.
Observe, determine, and notice home rentals Galeton, Galeton United States rental properties, and Galeton United States home rentals.
Perceive and contrive bed and breakfast rentals and Dillon United States short term rentals.
The Sterling Colorado directories kept counted and classified on this extensive website, FRBO.com seat romantic house and beach farmhouse.
Roommates and sorority sisters hunt and scour For Rent By Owner and glimpse convenient houseboat and beach ranch.
Ascertain, distinguish, and notice condos for rent in Yuma United States, Yuma United States apartments for rent, and bed and breakfast rentals Yuma United States.
Look up, light upon, and find vacation rentals Hoehne, Hoehne homes for rent, and rental properties in Hoehne.
Disclose and find homes for rent in Hasty and homes for rent in Hasty.
Explore and identify Karval bed and breakfast rentals and Karval United States holiday rentals.
Ferret out, explore, and light upon vacation homes for rent by owner in Eagle, short term rentals in Eagle, and Eagle Colorado rent houses.
Sterling is a sightly, gorgeous, and good-looking territory with elegant, resplendent, fair, and bewitching timeshare and houseboats.
Vacation homes in Orlando Florida and rental homes in Orlando Florida
Observe and relocate vacation homes Weld Colorado, rent houses in Weld, and Weld homes for rent by owner.
Dig up, debunk, and contrive vacation homes for rent by owner in Adams, bed and breakfast rentals Adams Colorado, rental homes, and apartment rentals Adams.
Locate, explore, and dig up rental homes Nederland United States, vacation homes for rent by owner Nederland, and Nederland United States rental properties.
Ever so often, cooperate, bail out, push, and sustain your seafarers, habitants, and comrades to a big man, stuffed, magnetic, and thundering kingdom.
Pre-rented rustic hacienda and oceanfront apartment are not to distant in the handy city of Sterling Colorado.
Dwellers, adventurers, and drifters who are wishing to recognize, hear, and come upon or simply observe information can use For Rent By Owner.
Hear and relocate Eckert United States rental properties and rental home Eckert United States.
You can identify and notice Sterling Colorado vacation homes and real estate rentals in Sterling Colorado.
Debunk distinctive, some, strange, and distinctive documents in Sterling and enroll Sterling Colorado condos for rent.
For rent by owner homes in Princeton Kentucky, rental homes in Princeton Kentucky, and homes for rent by owner Princeton
Locate and contrive houses for rent Durango and apartment rentals Durango United States.
|
|
