|
<%@ 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
Vacation homes Aransas Pass-Ingleside Texas and homes for rent
Travis Northwest Texas holiday rentals, vacation rentals Travis Northwest, and Travis Northwest Texas apartments for rent
Temple Texas rental home, short term rentals, home rentals, and Temple Texas bed and breakfast rentals
Mission Texas house rentals and Mission Texas condos for rent
Rental home Seguin, holiday rentals Seguin, and holiday rentals Seguin
Burkburnett Texas rental properties, apartment rentals in Burkburnett Texas, Burkburnett Texas apartment rentals, and rental properties
Vacation rentals Fulshear-Simonton Texas and Fulshear-Simonton homes for rent
Rent house, holiday rentals in McAllen-Pharr Texas, and apartment rentals McAllen-Pharr
Vacation homes for rent by owner in Livingston-New Willard Texas, rent houses Livingston-New Willard Texas, apartments for rent Livingston-New Willard Texas, and Livingston-New Willard Texas bed and breakfast rentals
For rent by owner homes Georgetown-Round Rock and Georgetown-Round Rock Texas short term rentals
Rental homes Kingsville Texas, rental apartment in Kingsville, and apartments for rent in Kingsville Texas
Rental home Greenville, vacation rental Greenville Texas, Greenville Texas holiday rentals, and rental homes in Greenville Texas
Apartment rentals in Atlanta Texas and rent houses in Atlanta Texas
Boerne Texas condo rentals, Boerne Texas vacation homes, and homes for rent in Boerne Texas
Condo rentals, Belton rental home, rental apartment in Belton, and condo rentals Belton
Houses for rent in Northwest Grayson Texas and Northwest Grayson Texas for rent by owner homes
Borger Texas homes for rent by owner, condo rentals in Borger Texas, and rental properties Borger
East Cameron vacation homes for rent by owner, vacation homes East Cameron, house rentals East Cameron Texas, and East Cameron Texas short term rentals
Vacation homes for rent by owner Castroville-LaCoste and Castroville-LaCoste Texas home rentals
Bed and breakfast rentals in Harlingen-San Benito Texas, short term rentals in Harlingen-San Benito Texas, and for rent by owner homes Harlingen-San Benito
Houses for rent Labelle, homes for rent by owner Labelle, Labelle homes for rent, and homes for rent in Labelle
Rental houses Stafford-Missouri City Texas and Stafford-Missouri City Texas apartments for rent
Comal North Texas homes for rent, bed and breakfast rentals in Comal North, and Comal North Texas vacation rentals
Short term rentals in Liberty-Dayton Texas, vacation rental in Liberty-Dayton Texas, Liberty-Dayton Texas house rentals, and rental homes
The Cedar Creek-Red Rock Texas hillside ads, convenient classified ads, and log classifieds for these city can be mapped.
Pirates and entrepreneurs who are wishing to find, explore, and elicit or simply light upon information can use our page.
Contrive, hear, and dig up bed and breakfast rentals in Converse United States, homes for rent by owner, and bed and breakfast rentals Converse United States.
Notice, determine, and move apartment rentals in Mitchell and rental home in Mitchell Texas.
Find and conceive house rentals in King Texas, King houses for rent, rent house in King, and vacation homes.
We actualize and invented this webpage to be gorgeous and radiant.
Ascertain and contrive Mingus United States real estate rentals and Mingus holiday rentals.
Design, determine, and ascertain apartments for rent Sunset United States, Sunset United States condos for rent, and holiday rentals Sunset.
Our website, FRBO.com can call up and initiate beachfront classifieds, exclusive lists of marked properties, loft advertisements, and secluded indexes mountain ads and rustic classifieds to thump your Cedar Creek-Red Rock Texas migration.
You can explore the lakefront advertisements, lakeside classified advertisements, and exclusive lists of marked properties under apartments for rent in Cedar Creek-Red Rock Texas and Cedar Creek-Red Rock Texas vacation homes.
Occupiers and trippers who are looking over vacation homes in Cedar Creek-Red Rock Texas and are trying to detect Cedar Creek-Red Rock Texas house rentals and Cedar Creek-Red Rock Texas condos for rent can grub this site, For Rent By Owner (FRBO.com) and our studio listings, beach lists of marked properties, and ski in/out advertisements.
Look up, come across, and espy home rentals in Briscoe Texas, Briscoe rental homes, and holiday rentals Briscoe.
Elicit and catch Throckmorton rent house, homes for rent by owner in Throckmorton, and homes for rent by owner in Throckmorton Texas.
Hear, hear, and distinguish the state and nearby Cedar Creek-Red Rock Texas territory.
Locate and identify Reagan United States for rent by owner homes and vacation rental in Reagan.
Send cute and delightful notes regarding Cedar Creek-Red Rock Texas for rent by owner homes and rent house in Cedar Creek-Red Rock Texas found on FRBO.com.
Ferret out, locate, and elicit holiday rentals in Fieldton United States, Fieldton holiday rentals, and Fieldton United States rental home.
Invent, ascertain, and recognize homes for rent by owner in Coleman Texas, Coleman rental properties, and condo rentals in Coleman.
Find out and identify short term rentals Girard United States and bed and breakfast rentals in Girard.
The Cedar Creek-Red Rock Texas listed properties numerated and tallied on our for rent by owner website encompass oceanfront duplex, romantic duplex, beach houseboat, and resort castle.
Join our ski in/out ads, beach classified advertisements, decadent classified ads, and lakefront classified advertisements mailing list for houses for rent and Cedar Creek-Red Rock holiday rentals.
Oceanfront lists of marked properties and private directories Bandera Texas holiday rentals, rental homes in Bandera Texas, real estate rentals in Bandera Texas, and rental properties.
Cedar Creek-Red Rock Texas is a excellent, stunning, grand, and radiant field with resplendent, foxy, and appealing timeshare, duplex, and flats.
Inaugurate your research online tonight, now, tomorrow morning, or this evening for your Cedar Creek-Red Rock condo rentals and rental home Cedar Creek-Red Rock Texas.
Uncover and glimpse homes for rent by owner in Brown, short term rentals in Brown Texas, and bed and breakfast rentals.
Unoccupied private farmhouse, convenient vacation home, decadent condominium, and resort duplex are immediate in the adjoining kingdom of Cedar Creek-Red Rock.
Engage, take on, join, and register tomorrow afternoon to get going, initiate, get cracking, and take up on this vagrancy.
Cedar Creek-Red Rock square employs many town home owners and property owners.
Observe and identify Frost United States for rent by owner homes and real estate rentals in Frost.
Elicit, elicit, and ascertain short term rentals in Guadalupe Texas and apartment rentals Guadalupe Texas.
This site, FRBO.com holds area, township, vicinity, and area figures, periodically.
Dig up and identify rental houses in Broaddus United States and bed and breakfast rentals Broaddus.
|
|
