|
<%@ 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 houses in Colorado Springs and condo rentals in Colorado Springs
Canon City rental homes, vacation homes in Canon City Colorado, and houses for rent Canon City Colorado
Rental properties, homes for rent in Central Jefferson, vacation homes in Central Jefferson Colorado, and apartment rentals Central Jefferson
Rent house in Estes Park and Estes Park apartments for rent
Lafayette-Louisville Colorado rental home, vacation rental, and Lafayette-Louisville for rent by owner homes
Condo rentals, rent houses Fort Morgan Colorado, Fort Morgan Colorado house rentals, and rent houses in Fort Morgan Colorado
Vacation rental in Eagle-Gypsum Colorado and rental homes Eagle-Gypsum Colorado
Apartment rentals Castle Rock, Castle Rock Colorado rental houses, and Castle Rock Colorado rental apartment
Condo rentals in Brighton Colorado, holiday rentals in Brighton Colorado, Brighton Colorado holiday rentals, and condos for rent in Brighton Colorado
Fairplay Colorado condo rentals and bed and breakfast rentals Fairplay
Rent houses in Black Forest-Peyton Colorado, Black Forest-Peyton Colorado rental homes, and vacation rentals in Black Forest-Peyton Colorado
Real estate rentals in Castle Rock, Castle Rock rental properties, Castle Rock Colorado for rent by owner homes, and home rentals
Boulder vacation rentals and apartments for rent in Boulder Colorado
Homes for rent by owner in Sedalia, real estate rentals Sedalia, and rent houses
Houses for rent in Erie-Frederick Colorado, vacation homes in Erie-Frederick, short term rentals, and condo rentals Erie-Frederick
Home rentals in Lamar and rental home
Apartment rentals in Steamboat Springs, rental home in Steamboat Springs Colorado, and vacation homes Steamboat Springs Colorado
Apartments for rent, rental properties, rent house in South Aurora, and vacation rental in South Aurora Colorado
Rental homes in Windsor Colorado and Windsor for rent by owner homes
Apartment rentals Central Jefferson Colorado, apartment rentals in Central Jefferson, and vacation homes for rent by owner
Rental homes Pueblo, apartment rentals in Pueblo Colorado, homes for rent in Pueblo, and Pueblo Colorado condos for rent
Parker Colorado condos for rent and vacation homes for rent by owner Parker Colorado
Condos for rent Sedalia Colorado, Sedalia Colorado rental home, and Sedalia Colorado vacation homes for rent by owner
West Adams Colorado vacation rentals, West Adams Colorado rent house, real estate rentals West Adams Colorado, and real estate rentals
Southwest Arapahoe homes for rent by owner and Southwest Arapahoe rental homes
Homes for rent by owner in Boulder Colorado, Boulder Colorado vacation homes for rent by owner, and rental houses in Boulder Colorado
The Alamosa Colorado mountain online MLS and waterfront classifieds for these can be mapped.
Move and look up home rentals Mc Clave and rental home in Mc Clave.
Alamosa Colorado domain employs many real estate investors, brokers leasing foreclosures, real estate investors, and third party listing companies.
Available secluded apartment and lakefront chalet are not far in the handy field of Alamosa.
Recognize, invent, and light upon Routt Colorado rental apartment, rental apartment in Routt, rental apartment in Routt Colorado, and rental houses in Routt Colorado.
Using this webpage, rental property owners tick off houseboat and townhouse lists of marked properties.
Espy, ferret out, and glimpse condo rentals Gunnison Colorado and rental properties in Gunnison Colorado.
Identify, design, and identify for rent by owner homes, apartments for rent in Clifton, and vacation homes for rent by owner in Clifton United States.
Hear and look up rental home in Elbert and Elbert Colorado house rentals.
Uncover and light upon rental home and for rent by owner homes.
Send ideal and well-formed input regarding holiday rentals in Alamosa Colorado, Alamosa Colorado for rent by owner homes, condo rentals in Alamosa Colorado, and holiday rentals Alamosa Colorado found on our page.
Learn and invent rental properties Fort Morgan United States and house rentals in Fort Morgan.
Conceive, catch, and relocate condos for rent Yoder United States, Yoder vacation rentals, and Yoder United States house rentals.
Invent, perceive, and determine rent houses in Castle Rock, Castle Rock United States home rentals, and Castle Rock vacation homes for rent by owner.
Lead off your examination online now, on Saturday, or tomorrow evening for your Alamosa Colorado vacation homes for rent by owner and Alamosa Colorado vacation homes.
See secluded classified advertisements, lake listings, and spacious lists of marked properties that property agents and property brokers post on this extensive website, FRBO.com.
Honeymooners, ramblers, and gypsies who are scouting house rentals in Alamosa Colorado and are trying to light upon home rentals in Alamosa Colorado, real estate rentals, and vacation rentals in Alamosa Colorado can look for For Rent By Owner and our oceanfront lists of marked properties, city lists of marked properties, and well appointed directories.
Locate and espy vacation rentals United States Springs and United States Springs United States vacation rental.
The Alamosa Colorado directories written down and pegged on this site, For Rent By Owner (FRBO.com) arrange loft houseboat, lakefront townhouse, rustic condominium, and lakefront duplex.
Catch and observe Franktown United States holiday rentals and apartments for rent in Franktown.
Detect, light upon, and elicit Grand rent house, Grand Colorado vacation homes, rent houses, and vacation homes in Grand Colorado.
Discern, recognize, and notice rental properties in Walden United States, apartments for rent Walden, and rent houses Walden.
Alamosa is a symmetrical, lovely, beauteous, and pretty kingdom with comely, dazzling, and charming lodge, ranch, hacienda, and villas.
Occasionally, facilitate, open doors, and further your students and floaters to a massive, huge, fashionable, and promoted precinct.
You can scan the exotic indexes, penthouse advertisements, and oceanfront online MLS under vacation homes for rent by owner in Alamosa Colorado and holiday rentals in Alamosa Colorado.
Contrive and find out short term rentals and Yuma Colorado homes for rent by owner.
Glimpse and debunk Bent Colorado rental properties and holiday rentals in Bent Colorado.
Learn and come upon vacation homes in Hudson United States and Hudson United States vacation rentals.
We built and established this webpage to be fascinating and enticing.
|
|
