Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-17T22:18:33.120' ,`MLSNumber` = '46932734' ,`ListAgentFullName` = 'Raquel Ginebra' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.818108' ,`Longitude` = '-95.296881' ,`PhotoCount` = '40' ,`PostalCode` = '77028' ,`RoomCount` = '3' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Howton' ,`StreetNumber` = '7317' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1669' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly updated home! Beautiful modern look with an open concept floor plan. New laminate vinyl flooring, new cabinets, and new granite! 3 new appliances, new AC, New electrical rewiring, new roof, new electrical panel, new water heater, new attic insulation and so much more! Gorgeous on the exterior as well as inside. You will not want to miss this Houston gem!' ,`Acres` = '0.1928' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 38 BLK 5 HOMESTEAD SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MCGOWEN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Homestead Sec 02' ,`TaxAmount` = '1338' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711859' WHERE `Matrix_Unique_ID` = '204328838' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-17T23:05:55.957' ,`MLSNumber` = '87661059' ,`ListAgentFullName` = 'Royce Price' ,`ListOfficeName` = 'Royce Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.105056' ,`Longitude` = '-99.192361' ,`PhotoCount` = '44' ,`PostalCode` = '78028' ,`RoomCount` = '4' ,`ListPrice` = '699999.00' ,`Status` = 'Active' ,`StreetName` = 'Arroyo' ,`StreetNumber` = '111' ,`StreetSuffix` = 'Trail' ,`City` = 'Kerrville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2198' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful property on 6 acres, just outside Kerrville city limits. Property offers 3BR/2Bath home w/loft, 1200 SQ FT metal building w/slab, 23x26 metal shed w/extra room, pool, seasonal pond & large front acreage field. Home was enlarged in 2008. Family living area includes: breakfast & kitchen area are open concept w/high ceilings in living room. Home office is off large dining, which can be used for office space or small family room. Spacious owner\'s suite/bedroom has room for bedroom set & extra seating space for large comfortable chair. Owner\'s suite bathroom offers dual sinks, jetted tub, large walk-in shower w/walk-in closet. Home also has a split floorplan w/possible family member living area w/separate kitchen & living area, & separate entry way, including large laundry room w/exterior access, cabinets, sink & space for extra fridge &/or freezer if needed. Beautiful view from front porch & field have additional access for ease of house entry way.' ,`Acres` = '6' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'WOOD TRAILS RCH LOT 70 ACRES 6.0' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '261360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '229 - Ingram' ,`SchoolElementary` = 'INGRAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'INGRAM-TOM MOORE SECONDARY SCHOOL' ,`SchoolMiddle` = 'INGRAM ELEMENTARY SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Photos/No Videos,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Wood Trails Rch' ,`TaxAmount` = '5784' ,`TaxRate` = '1.5387' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711859' WHERE `Matrix_Unique_ID` = '209176649' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-17T22:04:16.427' ,`MLSNumber` = '46226024' ,`ListAgentFullName` = 'Silvestre Serrano' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = 'Kevin Nguyen' ,`SellingOfficeName` = 'Lone Star Realty' ,`Latitude` = '29.550913' ,`Longitude` = '-95.524587' ,`PhotoCount` = '32' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '515000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Catania Bay' ,`StreetNumber` = '3918' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful lakefront 2-story home. The property features a high-ceiling entry, open floor plan, and a well-appointed kitchen. Extensive backyard deck with a barbecue grill perfect for whiling away your leisure time, admiring the lakefront scenery from sunset to sunrise, or simply wine and dine with family friends on a weekend, while the kids run & play. And, you don\'t have to drive anywhere to paddle your boat or canoe!' ,`Acres` = '0.1578' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE SHORE HARBOUR SEC 5, BLOCK 2, LOT 59' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '6875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PALMER ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Shore Harbour Sec 5' ,`TaxAmount` = '7973' ,`TaxRate` = '2.34' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711859' WHERE `Matrix_Unique_ID` = '209609638' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-17T23:22:53.067' ,`MLSNumber` = '51408414' ,`ListAgentFullName` = 'Deysi Howland' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.195833' ,`Longitude` = '-95.227259' ,`PhotoCount` = '48' ,`PostalCode` = '77357' ,`RoomCount` = '7' ,`ListPrice` = '510000.00' ,`Status` = 'Active' ,`StreetName` = 'Arrowhead' ,`StreetNumber` = '23976' ,`StreetSuffix` = 'Point' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2217' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for the perfect Home? RELAX AND ENJOY NATURE! Beautiful Ranch Style Home on 2 acres located in serene subdivision with lots of trees. It has 3 bedrooms, 2.5-baths, 2 car garage with plenty parking and huge 1000 sq ft workshop with electricity. Interior remodeled in 2020. Home offers open layout, high ceilings, spacious kitchen with exotic stone countertops and big island, tons of custom cabinet space, and stainless-steel appliances. Roomy bedrooms with walk-in closets. Updates include travertine floors throughout, frameless shower glass in Master Bath, recent kitchen and bathroom fixtures, new light fixtures, new water heater, fresh interior and exterior paint, new driveway for workshop. Abundant natural light & sounds of nature, peacefully quiet. Views of the forest from all windows. Great Location in a booming area. Close to Grand Texas Water Park. Minutes from restaurants and shopping center. Easy access to Hwy 242, Hwy 59 and Hwy 99. Don\'t wait!' ,`Acres` = '2' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'NORTHCREST RANCH 02, BLOCK 2, LOT 42, 50.000000% UDI' ,`LotDesciption` = 'Wooded' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Northcrest Ranch 02' ,`TaxAmount` = '3407' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711859' WHERE `Matrix_Unique_ID` = '210060769' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-17T23:06:48.763' ,`MLSNumber` = '2927580' ,`ListAgentFullName` = 'Jeni Gonzalez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.978071' ,`Longitude` = '-95.226238' ,`PhotoCount` = '27' ,`PostalCode` = '77396' ,`RoomCount` = '6' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Seco Creek' ,`StreetNumber` = '17811' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1848' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This wonderful home is move in ready ! Interior painted in 2022 with Sherwin Williams paint.\r\nLarge master bedroom with walk in closet and garden tub . Spacious family room with open concept to the kitchen/breakfast area. Carpets recently steamed cleaned. Stainless steel refrigerator stays!\r\nHome is in a great location with close proximity to shopping, dinning, parks , lakes and IAH airport !! \r\nThis is the one! Schedule a showing today! Click and see Video tour in photo section.' ,`Acres` = '0.122' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 3 LAUREL PLACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5314' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '565' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'LAKELAND ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'ROSS STERLING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Laurel Place Sec 01' ,`TaxAmount` = '4562' ,`TaxRate` = '2.933' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711859' WHERE `Matrix_Unique_ID` = '210478034' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-17T22:30:39.170' ,`MLSNumber` = '12006868' ,`ListAgentFullName` = 'Maria Polo' ,`ListOfficeName` = 'Victory Properties, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.521254' ,`Longitude` = '-95.444956' ,`PhotoCount` = '27' ,`PostalCode` = '77545' ,`RoomCount` = '4' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Renfro Burford' ,`StreetNumber` = '523' ,`StreetSuffix` = 'Road' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1736' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on the market! Buyer couldn\'t get approved for a loan! Beautiful 1 story brick and stone home with 3 bedrooms and two full bathrooms in Fresno. This property offers a private gate to access the property with lots of space in the from yard as well is the back. The inviting backyard with all the space for the kids to run around and a cover patio for those family BQQ\'s. Best of all, there are NO HOA FEES OR RESTRICTIONS. The kitchen is open to the breakfast area and it has a bar open to family room. Granite countertops. Stainless Steel appliances. Lots of cabinets. The laundry room is located inside the house. Tile floors. No carpet in this house.' ,`Acres` = '0.2187' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Mock Fireplace,Stove' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'RIDGEWOOD ESTATES, BLOCK 17, LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9528' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ridgewood Estates' ,`TaxAmount` = '5007' ,`TaxRate` = '2.7629' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711860' WHERE `Matrix_Unique_ID` = '211017522' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-17T22:22:41.877' ,`MLSNumber` = '26789479' ,`ListAgentFullName` = 'Sophia Pickens-Graves' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.782594' ,`Longitude` = '-95.328374' ,`PhotoCount` = '24' ,`PostalCode` = '77026' ,`RoomCount` = '6' ,`ListPrice` = '307000.00' ,`Status` = 'Active' ,`StreetName` = 'Abernathy' ,`StreetNumber` = '2204' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This modest home is ready for a growing and expanding family with neutral colors through out this lovely house. Kitchen boast granite counter tops, with ceramic title in all wet areas. Beautiful wood cabinets, spacious Primary bedrooms with plush carpet in all bedrooms and family room area. Located in the up and coming area of the greater 5th Ward. The edge of downtown Houston, Medical Center is nearby, NRG Stadium and the Houston Zoo. This is a must see, bring your first time buyer.' ,`Acres` = '0.0623' ,`Area` = '2' ,`BuilderName` = 'On Track Ministeies' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 ABERNATHY COURT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2713' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DOGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = '' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'ABERNATHY COURT' ,`TaxAmount` = '505' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711860' WHERE `Matrix_Unique_ID` = '211156120' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-17T22:13:43.200' ,`MLSNumber` = '85333294' ,`ListAgentFullName` = 'Guolong Li' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.697396' ,`Longitude` = '-95.783874' ,`PhotoCount` = '32' ,`PostalCode` = '77406' ,`RoomCount` = '3' ,`ListPrice` = '374999.00' ,`Status` = 'Active' ,`StreetName` = 'San Ricci' ,`StreetNumber` = '23526' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2139' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This beautifully maintained Ashton Woods home is located in the highly sought-after Lakes of Bella Terra community, with easy access to West Park Tollway, Highway 99/Grand Parkway, and I-10. Zoned to top rated schools in LCISD. Everything about this home has been tastefully chosen. From the modern brick and stone elevation to the up-to-date interior paint colors, it’s a decorators dream. The 3 bedroom and 2 1/2 bathroom open floor plan makes it the perfect space for family and guests. This home boasts a variety of upgrades from luxury vinyl plank flooring, to shaker-style white kitchen cabinets, quartz countertops, and a private extended primary retreat complete with vaulted ceilings. Ready for the kids, the backyard has been made into your own private playground. Extensive neighborhood amenities include tennis courts, gym, pools, dog parks, scenic walking trails, and so much more. Call or text to schedule your private showing today!' ,`Acres` = '0.1452' ,`Area` = '37' ,`BuilderName` = 'Ashton woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKES OF BELLA TERRA SEC 33, BLOCK 2, LOT 26' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUBENAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lakes Of Bella Terra Sec 33' ,`TaxAmount` = '8185' ,`TaxRate` = '3.0848' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711860' WHERE `Matrix_Unique_ID` = '211191765' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-17T22:59:27.037' ,`MLSNumber` = '8397056' ,`ListAgentFullName` = 'Erika Jones' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.123035' ,`Longitude` = '-95.546410' ,`PhotoCount` = '41' ,`PostalCode` = '77389' ,`RoomCount` = '9' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Aughton' ,`StreetNumber` = '25030' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful brick home is ready for you and move in ready. Entire home has fresh neutral paint throughout the interior and exterior, July \'22. As you enter the two story Foyer, the Formal Dining Room and Family Room are open, new ceiling fans, tile flooring, window blinds, and a cozy gas log fireplace. The Kitchen features a new gas range & vent hood, new LED recessed lights, spacious island w/storage, built in desk, spacious pantry, and a coat closet. Laundry room is off kitchen. Breakfast area has raised bar separating kitchen and wall of windows overlooking a big backyard. New HVAC was replaced in 2019. Powder bath is downstairs. The 1st floor Primary Bedroom 20x12 is has new carpet & ceiling fan. The Primary Bath has new lighting, new faucets, double sinks, new glass door to walk in shower, jetted tub, and His/Her closets. Upstairs has 1 bedroom, could be a 2nd primary BR +2 other spacious BR\'s. Full Bath Up. Game room w/built ins and walk in closet.' ,`Acres` = '0.1722' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 14 017*L5911553-002-014-008 LONDONDERRY SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'METZLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Londonderry Sec 02 R/P' ,`TaxAmount` = '7664' ,`TaxRate` = '2.834' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711860' WHERE `Matrix_Unique_ID` = '211407678' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-17T22:42:26.560' ,`MLSNumber` = '49430756' ,`ListAgentFullName` = 'Michael Sproba' ,`ListOfficeName` = 'Synergy Real Estate' ,`SellingAgentFullName` = 'Justice Eke' ,`SellingOfficeName` = 'Legacy Homes & Properties, LLC' ,`Latitude` = '30.098233' ,`Longitude` = '-95.428786' ,`PhotoCount` = '33' ,`PostalCode` = '77373' ,`RoomCount` = '12' ,`ListPrice` = '299900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Kobi Park' ,`StreetNumber` = '23206' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2342' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 23206 Kobi Park Ct! This spacious home is conveniently located with easy access to the Hardy Toll Rd, I-45, and 99 at the end of a cul-de-sac. Mature trees greet you in the front yard providing excellent shade on hot summer days. As you enter the home, you are welcomed by a a study or flex space and a formal dining room that leads to the kitchen. Kitchen boasts granite countertops, custom cabinetry, stainless steel appliances and a giant island for the chef in your life. Kitchen flows into the breakfast area and living room which are both accented by natural lighting from the large windows overlooking the backyard. Upstairs you will find all 3 bedrooms. Primary suite is complete with 2 sinks, a vanity, walk-in shower, jetted tub and walk-in closet. Low maintenance landscaping in the backyard with large patio and storage shed. Detached garage has ample room for extra storage space. This house is sure to be a hot commodity so come look at it today!' ,`Acres` = '0.1446' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 VILLAGE NORTHGATE CROSSING 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'NORTHGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'SPRINGWOODS VILLAGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Northgate Crossing' ,`TaxAmount` = '6351' ,`TaxRate` = '3.1142' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711860' WHERE `Matrix_Unique_ID` = '211514668' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','211996728','1663711860','211996728','2022-09-17T23:17:56.403','20043525','Michael Borrel','Keller Williams Realty - Memorial','Christian Luis','Krueger Real Estate','29.792503','-95.828216','28','77493','9','400000.00','Option Pending','Whispering Lakes','5972','Drive','Katy','2','1','4','2527','Single-Family','An extremely rare opportunity to purchase a home with a private lakefront view in one of Katy\'s most serene and convenient neighborhoods - Whispering Lakes! Located on the corner of the lake, this open-concept and updated home offers beautiful wood-look tile flooring, on-trend fixtures, and situated on one of the neighborhoods largest lots! Perfect for entertaining, the kitchen overlooks the living area and features an island, stainless steel appliances, and tons of storage. Enjoy evening sunsets across the lake from the spacious primary suite, located at the back of the home with an abundance of natural light. The ensuite bath features a standalone glass shower, spacious closet, and a separate soaking tub. As an added bonus, the second floor features a landing area/flex space that can be used as a game room or media room! Refrigerator included!','0.23','25','','','','','Sellers Disclosure','1','','1','Katy - Old Towne','Central Gas','1','S938901 WHISPERING LAKES (REPLAT) BLK 2 LOT 19','Subdivision Lot,Water View','10041','Appraisal District','','785','0','','2','','0','','','','','Composition','30 - Katy','KATY ELEMENTARY SCHOOL','KATY HIGH SCHOOL','KATY JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Whispering Lakes Rep','6387','2.4777','Public Sewer,Public Water','2002','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-17T22:46:38.230' ,`MLSNumber` = '96714193' ,`ListAgentFullName` = 'Jennifer Tucker' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Jennifer Tucker' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.664270' ,`Longitude` = '-95.732947' ,`PhotoCount` = '24' ,`PostalCode` = '77407' ,`RoomCount` = '7' ,`ListPrice` = '342900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Mission Lake' ,`StreetNumber` = '4934' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2039' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 4934 Mission Lake Court. This flexible 3 or 4 bedroom, 2 bath home is located in Waterside Village with close proximity to the Grand Parkway, shopping, and all the amenities. This home boasts fresh updates including new paint and floors inside. Outside you will find a spacious backyard perfect for entertaining including an outdoor kitchen area. Come see it today!' ,`Acres` = '0.2549' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WATERSIDE VILLAGE SEC 1, BLOCK 2, LOT 9' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11103' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '590' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OAKLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Waterside Village Sec 1' ,`TaxAmount` = '4995' ,`TaxRate` = '2.2929' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663711860' WHERE `Matrix_Unique_ID` = '212006147' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212145678','1663711860','212145678','2022-09-17T22:58:48.273','47962540','Chris Carpentier','JLA Realty','','','30.704485','-95.089987','46','77351','3','479900.00','Active','Nugent','280','Drive','Livingston','2','0','3','1568','Single-Family','Beautiful open waterfront lots. These lots are absolutely beautiful with lots of shade and amazing trees that help create privacy. The home has been lovingly maintained and offers 3 bedrooms and 2 full baths, lots of cabinets and storage space and amazing views. Large front porch and great back porch with built in benches for lots of seating. The owner recently added an 85k $ boat house that is beautiful and provides for remote boat lift and 2 jet ski lift that is also remote, large seating area and swim platform for enjoyment and to help get in boat much easier. You will enjoy sunrise and sunset views from your pier. Schedule your tour today and start making memories soon!','0.72','44','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Lake Livingston Area','Propane','1','NUGENT\'S COVE SECTION 1 BLK 13 LOT 13 & 14 MH 56 X 28 NO TAG','Subdivision Lot,Waterfront,Wooded','31240','Appraisal District','','110','0','','0','Electric Oven','0','','','Electric Cooktop','','Aluminum','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Ranch','Nugents Cove Sec 1','2495','1.9558','Public Water,Septic Tank','1984','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212235088','1663711861','212235088','2022-09-17T23:38:52.410','78560844','Lillian Ballard','UTR TEXAS, REALTORS','','','29.732563','-95.294835','29','77011','10','357770.00','Active','Texas','7334','Street','Houston','3','0','3','1782','Single-Family','Welcome home! Seller has been working hard to bring you a beautiful property w/potential to be a income producing property as well as a home. Updating this 1930\'s bungalow w/modern flare while keeping the original charm has been achieved in this home. Just minutes from everything Houston has to offer. Nestled in the East End Revitalized area of Houston (EADO) w/light rail around the corner. All work done by seller was done in 2022. Main house 3 bdrm 2 full bath, vinyl plank floor in living area with a beautiful tile in the restrooms. Plush carpet in bdrms. Main house boast brush nickel finishes, recessed lighting, ceiling fans, stainless steal appliances, updated plumbing with pex piping, new electrical wiring, new roof, new HVAC. Apartment in the rear 2 bdrm 1 full bath, great finishes for a income producing unit, brushed nickel, stainless appliance mini size, vinyl plank in living area, tile in bath and carpet bdrms. Split unit AC down, window units in bdrms. Call today! Must See!','0.0976','4','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','East End Revitalized','Central Gas','0','LT 9 BLK 4 SCHMOELLER','Cleared','4250','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','BRISCOE ELEMENTARY SCHOOL','AUSTIN HIGH SCHOOL (HOUSTON)','EDISON MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Schmoeller','2364','2.3307','Public Sewer,Public Water','1936','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212431014','1663711861','212431014','2022-09-17T22:13:02.670','72939689','Emily McCollum','Keller Williams Hou Preferred','Dustin Bauer','Logos Investment Properties','29.396235','-95.223494','50','77511','7','350000.00','Option Pending','Crestmont','204','Drive','Alvin','2','0','3','2391','Single-Family','Beautifully updated home in the quaint community of Hillcrest Village. This 3 bedroom 2 bath home sits on over a quarter of an acre. The backyard is fully fenced & offers plenty of shade with the mature oak trees. As you enter, you will see new laminate wood floors that continue through the main areas of the home & to your left a grand dining room with a custom built China Hutch. The dining area flows into the open floor plan kitchen and living room. The tastefully updated kitchen includes dark natural colored cabinets with gorgeous quartz countertops & marble-like subway tile backsplash. The kitchen island is the focal point of the room & is the place for your guests to gather - this layout is perfect for entertaining! A few other updates include: 1 year old roof, pex plumbing lines, double paned windows, primary and guest bathroom remodeled, & the foundation has been leveled with transferable warranty. Not many homes in the neighborhood go up for sale that are this move in ready!','0.3489','5','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','Gaslog Fireplace','1','Alvin South','Central Gas','0','HILLCREST VILLAGE (A0161 B B B & C), LOT 44-W/2 LOT 43','In Golf Course Community,Subdivision Lot','15198','Appraisal District','','','0','','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','3 - Alvin','WALT DISNEY ELEMENTARY SCHOOL','ALVIN HIGH SCHOOL','ALVIN JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Hillcrest Village','6601','2.5148','Public Sewer,Public Water','1962','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212653571','1663711861','212653571','2022-09-17T22:14:46.300','55728696','Lauren Luneau','Century 21 Realty Partners','','','30.226464','-95.659401','46','77354','11','600000.00','Active','Stallion','12406','Court','Magnolia','3','1','5','3914','Single-Family','Extra Large Traditional Home at the end of a quiet cul-de-sac. This home offers something for everyone: 5 Bedrooms, 3.5 baths & a 3 car garage. Immaculate. Updated wood floors. Cook for a crowd in the huge Kitchen with stainless steel appliances (standard & convection ovens), expansive countertops, and walk-in pantry. Perfect home for Entertaining: Dedicated Dining. Cathedral ceiling Living Room. Family Room with fireplace open to the Kitchen. Upstairs Game Room & Study area. Primary Bedroom on main floor w/ attached full Bath w/ dual sinks, oversized tub & shower, walk-in closet w/ natural light. Home Office w/ 2 sets of French Doors. Upstairs: 4 Bedrooms, 2 Baths, & an enormous Game Room. Private backyard with Mature Trees & Beautiful Landscaping. Tankless hot water heater & Ecobee thermostat. LOW taxes/No MUD. Zoned to Magnolia ISD with the prestigious IB program. The best of country living only 6 miles from The Woodlands & minutes from the new Aggie Expressway. No Flooding.','0.657','15','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Magnolia/1488 East','Central Gas','1','MOSTYN MANOR 02, BLOCK 2, LOT 16, ACRES 0.660','Cul-De-Sac,Subdivision Lot','28620','Appraisal District','','500','0','','3','Convection Oven,Double Oven','0','','','Gas Cooktop','','Composition','36 - Magnolia','MAGNOLIA PARKWAY ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Mostyn Manor','8825','1.8587','Aerobic','2003','Appraisal District'); --> New record created successfully