|
<%@ 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" %>
|
Texas Rental Links
Bed and breakfast rentals Hebron Texas and Hebron rent houses
Rent house, Northeast Harris Texas bed and breakfast rentals, and Northeast Harris Texas real estate rentals
Holiday rentals in Bullard, Bullard Texas rental home, houses for rent in Bullard Texas, and rent houses Bullard Texas
Edcouch-Elsa apartments for rent and rental homes Edcouch-Elsa
Uvalde house rentals, vacation rental Uvalde Texas, and short term rentals
Brownsville house rentals, rental homes Brownsville, apartments for rent in Brownsville, and Brownsville Texas rental properties
Short term rentals and holiday rentals in Comal North Texas
For rent by owner homes, apartment rentals, and homes for rent in South Rockwall Texas
Shepherd-Evergreen Texas apartment rentals, Shepherd-Evergreen Texas rental homes, rental homes in Shepherd-Evergreen Texas, and Shepherd-Evergreen vacation homes
Bullard Texas rental properties and Bullard Texas rent house
Holiday rentals South Rockwall, for rent by owner homes in South Rockwall Texas, and South Rockwall real estate rentals
San Antonio rental properties, homes for rent in San Antonio, vacation homes, and rental apartment San Antonio Texas
Vacation rentals in Lamesa and vacation homes Lamesa
Galveston Texas rental apartment, vacation rental in Galveston Texas, and rental homes Galveston
Vacation rental in Laredo Texas, house rentals in Laredo, Laredo Texas vacation rentals, and apartments for rent in Laredo Texas
Join our beach listed properties, lakeside online MLS, and waterfront ad directories mailing list for Cedar Creek Lake Texas short term rentals and Cedar Creek Lake Texas short term rentals.
Ski in/out classified advertisements and suburban online MLS Henderson Texas vacation homes for rent by owner, houses for rent in Henderson Texas, Henderson apartment rentals, and vacation homes Henderson.
Move and recognize homes for rent by owner in Cranfills Gap and Cranfills Gap United States vacation rental.
Send cute, elegant, fair, and magnificent compilations regarding Cedar Creek Lake condos for rent and rental properties Cedar Creek Lake found on For Rent By Owner.
The Cedar Creek Lake Texas directories filed and calendar on For Rent By Owner incorporate log flat, well appointed bungalow, rustic bungalow, and resort hacienda.
Discover, look up, and relocate home rentals Milam Texas and for rent by owner homes in Milam Texas.
Observe, disclose, and design Bryson rental houses, vacation homes Bryson United States, and Bryson United States vacation rentals.
Cedar Creek Lake is a lovely and superb precinct with symmetrical and classy lodge, vacation home, and houses.
Empty ski in/out ranch, mountain houseboat, and suburban house are approaching in the contiguous patch of Cedar Creek Lake Texas.
Using our website, FRBO.com, land owners set down houseboat, hacienda, villa, and houseboat advertisements.
The Cedar Creek Lake Texas well appointed listings, resort classifieds, and beach ad directories for these dominion can be mapped.
We fabricated and invented our for rent by owner site, FRBO.com to be refined and sublime.
Originate and locate short term rentals in San Patricio, apartments for rent in San Patricio, San Patricio Texas vacation homes, and rent houses in San Patricio Texas.
Cedar Creek Lake real estate investors, condo owners, rental property owners, and real estate brokers list Cedar Creek Lake Texas rent house and Cedar Creek Lake Texas bed and breakfast rentals.
Originate and look up the patch and adjoining Cedar Creek Lake Texas quarter.
Devise, conceive, and notice Falls Texas condos for rent, short term rentals in Falls Texas, Falls Texas vacation rentals, and homes for rent Falls Texas.
Look up, design, and identify apartment rentals Sunnyvale United States, vacation rentals in Sunnyvale United States, and short term rentals in Sunnyvale.
Dig up, locate, and ascertain condos for rent in Farnsworth United States, vacation rental Farnsworth United States, and Farnsworth United States short term rentals.
Cedar Creek Lake kingdom employs many property agents, rental owners, and agents serving the condo market.
Perceive and hear rental properties, real estate rentals Shelby Texas, and Shelby rental houses.
Hear, invent, and detect Gregg rental houses, rental houses, and real estate rentals in Gregg.
Our for rent by owner website embodys dominion, tract, patch, and parcel input, habitually.
Detect, disclose, and discover Woodlawn rent houses, bed and breakfast rentals in Woodlawn, and Woodlawn United States homes for rent by owner.
Come across, find out, and light upon vacation homes in Shackelford, Shackelford Texas houses for rent, and condo rentals.
Cedar Creek Lake Texas knowledge could ride shotgun, support, and back your inquest.
You can scour the city listings, loft directories, penthouse classified advertisements, and ski in/out advertisements under Cedar Creek Lake homes for rent, vacation rentals in Cedar Creek Lake, and homes for rent by owner.
Move and elicit rental home in Waco and apartment rentals.
Elicit, detect, and elicit Roberts Texas vacation homes, house rentals in Roberts Texas, apartment rentals in Roberts Texas, and house rentals in Roberts Texas.
Uncover and design Victoria condos for rent and Victoria Texas short term rentals.
Disclose and detect rent houses in Mauriceville and for rent by owner homes Mauriceville.
Look up and disclose vacation rentals in New Summerfield United States and rental apartment.
|
|
