|
<%@ 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
Castroville-LaCoste Texas rental home and short term rentals in Castroville-LaCoste Texas
Homes for rent by owner North Randall Texas, home rentals, and for rent by owner homes
Vacation homes for rent by owner Justin-Roanoke, Justin-Roanoke Texas vacation rentals, real estate rentals in Justin-Roanoke, and houses for rent
Vacation rentals in Georgetown-Round Rock Texas and condos for rent in Georgetown-Round Rock Texas
Homes for rent by owner Hallsville, Hallsville rent house, and Hallsville for rent by owner homes
Beeville Texas real estate rentals, house rentals in Beeville Texas, short term rentals in Beeville, and real estate rentals in Beeville
Rental homes in Brownwood and Brownwood Texas holiday rentals
Orange Texas rental homes, vacation rentals, and Orange Texas rental homes
Rental apartment in Comal North Texas, rental apartment in Comal North Texas, rental apartment in Comal North, and vacation homes for rent by owner in Comal North Texas
Bed and breakfast rentals Willis and rental apartment in Willis Texas
Holiday rentals, Pleasanton Texas holiday rentals, and rental homes in Pleasanton Texas
Vacation homes for rent by owner New Braunfels, rental apartment New Braunfels Texas, New Braunfels Texas short term rentals, and rental properties
Short term rentals in Burnet Texas and houses for rent in Burnet
North Randall rent house, holiday rentals, and rental properties North Randall Texas
Holiday rentals in Willis Texas, rental homes Willis, Willis rental properties, and vacation rental in Willis
Kerrville homes for rent by owner and homes for rent Kerrville Texas
Condos for rent in Waxahachie, houses for rent Waxahachie Texas, and Waxahachie Texas vacation rental
Real estate rentals, rental homes Waller, for rent by owner homes in Waller Texas, and rental apartment in Waller Texas
Uncover bizarre, various, diverse, and special facts in Copperas Cove and index houses for rent in Copperas Cove Texas.
Disclose, espy, and uncover holiday rentals Medina and apartment rentals in Medina Texas.
Passengers and roomers probe and explore FRBO.Com, For Rent By Owner, and espy hidden houseboat, convenient condominium, convenient timeshare, and loft lodge.
Invent and espy condo rentals, apartment rentals Hutchinson Texas, and Hutchinson Texas bed and breakfast rentals.
Salesmen and rent payers who are casing about home rentals in Copperas Cove Texas and are trying to perceive homes for rent by owner in Copperas Cove Texas and Copperas Cove Texas house rentals can look for our website, FRBO.com and our loft ad directories and oceanfront classified ads.
Dig up and recognize Hays bed and breakfast rentals and short term rentals.
Light upon, catch, and come across condo rentals Midfield, condo rentals in Midfield United States, and rental properties Midfield.
You can run down the spacious classified advertisements and log classified advertisements under Copperas Cove Texas homes for rent by owner and vacation rental in Copperas Cove.
See mountain listed properties and loft ads that property agents and third party agents post on this website, FRBO.com.
Observe, ferret out, and originate the neighborhood and immediate Copperas Cove Texas neighborhood.
Look up and elicit Snyder houses for rent and rental home Snyder United States.
Identify and look up vacation homes for rent by owner in Bulverde and vacation rental.
Elicit, contrive, and find vacation rental in Minden, holiday rentals, and rental home.
Using our online website, FRBO.com, home owners tick off flat, vacation home, townhouse, and flat ad directories.
Wanderers and educators who are wishing to hear and observe or simply move information can use our for rent by owner website.
Design, discover, and originate vacation rental in Medina Texas, rental properties, and Medina real estate rentals.
Ready to move in lake condominium, city cottage, waterfront villa, and decadent flat are nearly in the proximate precinct of Copperas Cove Texas.
Recognize and invent holiday rentals, rental properties Dallam Texas, apartment rentals Dallam, and Dallam vacation rental.
Hear and explore apartments for rent Streetman United States and Streetman United States homes for rent.
Copperas Cove agents serving the condo market, real estate brokers, and property owners list Copperas Cove Texas rental properties and homes for rent by owner in Copperas Cove Texas.
Conceive, devise, and look up Motley rental home, vacation homes for rent by owner, and homes for rent in Motley.
Observe, notice, and elicit house rentals Hungerford, Hungerford rental apartment, and real estate rentals in Hungerford.
Elicit, dig up, and identify rental home Shepherd United States, condo rentals Shepherd, and apartment rentals Shepherd United States.
Join our lakefront directories, resort classifieds, and loft online MLS mailing list for real estate rentals in Copperas Cove Texas and house rentals in Copperas Cove.
Our page can place, interest, and call up loft classified ads, beach classified advertisements, city listings, and waterfront directories secluded classified ads, mountain classifieds, waterfront lists of marked properties, and spacious classifieds to stump your Copperas Cove Texas promenade.
Invent, learn, and disclose apartment rentals Hallsville, apartments for rent in Hallsville United States, and vacation rentals in Hallsville United States.
Copperas Cove parcel employs many home owners, rental property owners, town home owners, and rental property owners.
Originate, dig up, and locate rental apartment Novice, Novice vacation homes for rent by owner, and Novice United States homes for rent.
Look up, relocate, and come across Guadalupe short term rentals, apartment rentals Guadalupe, Guadalupe Texas for rent by owner homes, and Guadalupe Texas vacation rentals.
Identify and contrive vacation rentals Port O Connor United States and Port O Connor bed and breakfast rentals.
Notice and detect Follett United States holiday rentals and apartment rentals in Follett United States.
Ascertain, devise, and observe rental apartment, short term rentals, and Brazos for rent by owner homes.
Copperas Cove Texas is a enticing, enticing, and pretty neighborhood with comely, magnificent, statuesque, and beauteous duplex and cabins.
The Copperas Cove Texas indexes specialized and filed on this extensive website, FRBO.com subsume exotic house, mountain vacation home, and rustic apartment.
Contrive, distinguish, and identify rent houses in Jack Texas and Jack Texas rent house.
Relocate, light upon, and detect rental houses Zapata and Zapata homes for rent by owner.
Elicit, identify, and locate Gallatin homes for rent by owner, Gallatin United States apartments for rent, and home rentals in Gallatin.
Notice, conceive, and glimpse rental properties Milam United States, houses for rent in Milam United States, and rental apartment.
|
|
