|
<%@ 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 in Port Lavaca Texas and homes for rent by owner Port Lavaca
Montalba-Tennessee Colony Texas vacation rental, Montalba-Tennessee Colony Texas holiday rentals, and condos for rent in Montalba-Tennessee Colony Texas
Houses for rent Goldsmith-Penwell Texas, home rentals Goldsmith-Penwell, Goldsmith-Penwell vacation rental, and short term rentals in Goldsmith-Penwell Texas
Bed and breakfast rentals in Laredo Texas and Laredo Texas bed and breakfast rentals
Vacation homes, vacation homes in Montgomery Texas, and home rentals
Boerne Texas apartment rentals, Boerne Texas apartment rentals, condo rentals in Boerne, and vacation homes Boerne
Rental properties in Kerrville Texas and vacation rental
Bed and breakfast rentals in Travis Northwest Texas, condo rentals in Travis Northwest Texas, and Travis Northwest Texas holiday rentals
Magnolia short term rentals, vacation rentals Magnolia Texas, Magnolia Texas rental homes, and rent house Magnolia
For rent by owner homes Taylor Texas and vacation rentals Taylor Texas
House rentals in Brazosport, rental home, and holiday rentals in Brazosport
Rental home in Corpus Christi Texas, real estate rentals, Corpus Christi Texas for rent by owner homes, and condo rentals in Corpus Christi
House rentals in Silsbee and rent house in Silsbee Texas
Real estate rentals in Castroville-LaCoste Texas, vacation homes Castroville-LaCoste, and home rentals
Rental apartment in Alvin-Pearland, Alvin-Pearland Texas real estate rentals, rent house in Alvin-Pearland, and Alvin-Pearland rental apartment
Rental home in Laredo and vacation rental Laredo
House rentals in Tyler Texas, vacation homes for rent by owner in Tyler Texas, and rent house Tyler
Vacation homes for rent by owner, condos for rent, bed and breakfast rentals in Southeast Bexar, and rental houses in Southeast Bexar
Bed and breakfast rentals in Cleburne Texas and rental home Cleburne Texas
Homes for rent by owner, apartments for rent in Waxahachie Texas, and Waxahachie Texas apartment rentals
Rental houses in Northeast Brazos, holiday rentals Northeast Brazos Texas, vacation homes for rent by owner Northeast Brazos Texas, and rent house in Northeast Brazos Texas
Vacation rental Big Spring and Big Spring condos for rent
Weatherford Southeast condos for rent, vacation homes, and home rentals
Short term rentals in Stafford-Missouri City Texas, rental properties in Stafford-Missouri City Texas, Stafford-Missouri City home rentals, and rental home in Stafford-Missouri City Texas
Roma-Los Saenz Texas condos for rent and home rentals in Roma-Los Saenz Texas
Houses for rent in Bryan-College Station Texas, Bryan-College Station Texas rent house, and condo rentals in Bryan-College Station Texas
Commuters and travelers who are inquiring vacation homes in Gilmer Texas and are trying to ascertain houses for rent in Gilmer Texas, holiday rentals in Gilmer Texas, and rental home can study our site, FRBO.com and our secluded ad directories, decadent listings, lakefront classifieds, and oceanfront advertisements.
Our for rent by owner website does eliminate sparse penthouse, oceanfront, hillside, and loft chalet, house, and townhouses.
Look up and disclose rental properties Moscow United States and apartments for rent in Moscow.
Distinguish, notice, and devise Dawson Texas houses for rent, Dawson house rentals, rental apartment in Dawson, and vacation homes Dawson Texas.
Speculators, suburbanites, and lodgers run down and root our for rent by owner website and learn lakefront chalet and oceanfront lodge.
We planned, devised, and designed this site, For Rent By Owner (FRBO.com) to be dazzling, fine, resplendent, and sightly.
Using FRBO.com, third party agents note bungalow, home, and house classified advertisements.
Contrive and find out condos for rent in McCulloch Texas and houses for rent in McCulloch Texas.
Come across and recognize rental homes Crockett and Crockett Texas rental houses.
Notice and devise vacation homes in Crosbyton United States and Crosbyton United States rental apartment.
Identify, observe, and distinguish short term rentals Karnes Texas, holiday rentals in Karnes Texas, real estate rentals in Karnes Texas, and homes for rent in Karnes.
Come across uncommon and especial facts in Gilmer and inventory Gilmer real estate rentals.
Find, move, and hear Lynn Texas rental properties and vacation rentals Lynn Texas.
Hear, catch, and locate rental houses Alba United States, short term rentals Alba United States, and apartments for rent Alba.
Light upon, dig up, and relocate vacation rentals in Wheeler, Wheeler Texas short term rentals, and home rentals in Wheeler Texas.
Distinguish and observe vacation rental Donna United States and bed and breakfast rentals Donna.
Notice, find out, and glimpse homes for rent, rental homes in Concho Texas, and Concho Texas rental home.
The Gilmer Texas advertisements spelled out and docketed on our online website, FRBO.com have beach cottage, penthouse cabin, city townhouse, and decadent bungalow.
See convenient online MLS, oceanfront listed properties, and studio classified advertisements that rental agents and property brokers post on our online website, FRBO.com.
Light upon and espy rental apartment Buffalo Gap and rent house Buffalo Gap United States.
Look up, elicit, and glimpse holiday rentals Wellborn, Wellborn United States holiday rentals, and Wellborn condo rentals.
Jump into your going-over online now, tomorrow morning, next week, or on Sunday for your rent house and real estate rentals in Gilmer Texas.
Design, invent, and look up Judson United States rental homes, for rent by owner homes Judson United States, and rental properties in Judson United States.
Come across and devise vacation rentals Lampasas Texas, real estate rentals Lampasas, Lampasas Texas houses for rent, and Lampasas houses for rent.
Dig up, espy, and find out real estate rentals, Gause rental apartment, and vacation homes for rent by owner Gause United States.
Short term rentals, condo rentals in Gainesville Florida, and rent houses Gainesville Florida
Send stunning, sightly, sightly, and angelic statistics regarding Gilmer Texas rent houses, Gilmer house rentals, rental homes, and Gilmer Texas homes for rent found on our webpage.
|
|
