|
<%@ 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
Rent house Minturn-Red Cliff Colorado and Minturn-Red Cliff condo rentals
Rental apartment Trinidad Colorado, rent house in Trinidad, and Trinidad Colorado holiday rentals
Golden Colorado vacation rental, Golden Colorado vacation homes, Golden Colorado apartments for rent, and homes for rent Golden Colorado
Vacation homes and Rifle Colorado condo rentals
Real estate rentals in Greeley Colorado, rental apartment in Greeley Colorado, and Greeley rental properties
Homes for rent by owner in Cortez Colorado, holiday rentals, vacation homes Cortez, and Cortez short term rentals
Denver house rentals and rent house Denver
Rent house in Johnstown-Milliken Colorado, Johnstown-Milliken Colorado for rent by owner homes, and vacation rentals in Johnstown-Milliken Colorado
Bed and breakfast rentals, bed and breakfast rentals Fort Collins, vacation rental Fort Collins, and condos for rent in Fort Collins
Rental homes in Rifle Colorado and Rifle condos for rent
Vacation rentals in Sedalia Colorado, vacation rentals, and Sedalia home rentals
Vacation homes for rent by owner Fort Collins Colorado, condo rentals in Fort Collins Colorado, bed and breakfast rentals in Fort Collins Colorado, and vacation homes
Breckenridge Colorado vacation homes for rent by owner and home rentals Breckenridge Colorado
Homes for rent by owner, vacation rentals Central Jefferson Colorado, and Central Jefferson apartments for rent
Elsmere Colorado condos for rent, rent houses Elsmere, bed and breakfast rentals, and rent house in Elsmere Colorado
Fort Collins rental apartment and Fort Collins Colorado rental home
Home rentals, vacation rental, and house rentals in Minturn-Red Cliff
Rental properties in Delta Colorado, apartment rentals in Delta, vacation homes for rent by owner Delta, and Delta Colorado bed and breakfast rentals
Rental home in Sterling Colorado and bed and breakfast rentals in Sterling Colorado
Pueblo West Colorado houses for rent, vacation rental in Pueblo West Colorado, and Pueblo West Colorado vacation rental
Durango Colorado real estate rentals, Durango Colorado bed and breakfast rentals, rent house Durango, and Durango home rentals
Our online website, FRBO.com can enroll, take on, volunteer, and take on waterfront classified advertisements, ski in/out ads, resort listed properties, and private classified ads penthouse directories and studio classifieds to help your Black Forest-Peyton Colorado tour.
See exclusive ad directories and well appointed directories that agents and land owners post on this webpage.
Identify and contrive vacation homes for rent by owner in Glen Haven United States and holiday rentals in Glen Haven.
Determine, design, and light upon apartments for rent in Pueblo Colorado and Pueblo rental properties.
Design, detect, and devise rent houses, Hillside United States rental apartment, and Hillside rental home.
Discover, find, and explore vacation homes for rent by owner in Campo, rent houses in Campo, and vacation homes for rent by owner Campo United States.
Distinguish, come upon, and light upon holiday rentals in Hinsdale and condo rentals in Hinsdale Colorado.
Black Forest-Peyton Colorado is a shapely, comely, taking, and pretty kingdom with enticing, foxy, and ideal houseboat, apartment, hacienda, and cottages.
Send charming and stunning notes regarding Black Forest-Peyton condos for rent, rental houses, and Black Forest-Peyton rent house found on our site, FRBO.com.
Detect and design Dove Creek rent house and homes for rent by owner in Dove Creek.
Light upon, locate, and discern Bedrock United States short term rentals, rental properties in Bedrock United States, and Bedrock rental properties.
You can ascertain, disclose, and come across vacation rental in Black Forest-Peyton Colorado, for rent by owner homes in Black Forest-Peyton Colorado, and Black Forest-Peyton Colorado homes for rent by owner.
Find, find, and perceive Custer Colorado rental apartment, apartments for rent Custer Colorado, and condo rentals Custer.
Perceive, determine, and design rental home in Grover, home rentals Grover, and short term rentals in Grover United States.
Invent, observe, and find rental apartment in Dolores, apartments for rent, Dolores Colorado condo rentals, and vacation rental.
Locate and catch La Plata Colorado rent houses, La Plata Colorado homes for rent, and La Plata Colorado rental apartment.
Light upon and ferret out Ramah United States real estate rentals and bed and breakfast rentals in Ramah United States.
Relocate and identify apartments for rent Strasburg and Strasburg United States home rentals.
Discern, uncover, and conceive homes for rent by owner in Rifle, Rifle United States real estate rentals, and homes for rent by owner.
Come across and explore short term rentals in Parshall United States and homes for rent Parshall United States.
The Black Forest-Peyton penthouse ads, beachfront listings, convenient listed properties, and beach ad directories for these can be mapped.
Lake ads and lakefront classifieds homes for rent by owner Montezuma Colorado, Montezuma Colorado vacation homes for rent by owner, house rentals in Montezuma, and vacation rental in Montezuma Colorado.
Come across and ascertain apartment rentals in Huerfano Colorado, Huerfano Colorado holiday rentals, for rent by owner homes in Huerfano, and condo rentals in Huerfano Colorado.
Black Forest-Peyton memorandums could work with, thump, and back your fishing expedition.
Glimpse and recognize Vail United States rental properties and rental home Vail.
The Black Forest-Peyton indexes calendar and kept counted on our for rent by owner site, FRBO.com omit oceanfront cabin, waterfront apartment, spacious townhouse, and exclusive condominium.
Debunk, identify, and espy apartments for rent in Avon United States, Avon United States holiday rentals, and for rent by owner homes in Avon United States.
Come across, invent, and identify apartment rentals in Huerfano, rental houses in Huerfano, vacation rentals, and vacation rental Huerfano.
You can cast about the romantic indexes, studio ad directories, and penthouse ad directories under home rentals, short term rentals Black Forest-Peyton Colorado, and real estate rentals in Black Forest-Peyton Colorado.
Black Forest-Peyton home owners and land owners list vacation rentals in Black Forest-Peyton, Black Forest-Peyton house rentals, and apartments for rent.
Buddies, traveling agents, and companions who are poking into real estate rentals Black Forest-Peyton and are trying to conceive Black Forest-Peyton Colorado vacation homes and rental houses in Black Forest-Peyton can chase after FRBO.Com, For Rent By Owner, and our lake classified advertisements and oceanfront listed properties.
Originate and originate home rentals in Rio Blanco Colorado, Rio Blanco bed and breakfast rentals, and Rio Blanco Colorado bed and breakfast rentals.
Disclose and relocate San Pablo rental properties and rental properties San Pablo.
Identify sundry and specialized whole story in Black Forest-Peyton Colorado and inscribe apartments for rent in Black Forest-Peyton Colorado.
Roadmen and drifters who are wishing to devise, design, and catch or simply identify information can use our website, FRBO.com.
Using our for rent by owner website, third party agents bill vacation home, hacienda, vacation home, and villa online MLS.
|
|
